In this project, I will attempt to predict whether, for any given parcel in Detroit with a building on it, whether a building on that parcel will be be targetted for demoltion. Potential predictors, downloaded from https://data.detroitmi.gov/, include citations relatated to the building, crime, and complaints concerning the building related to blight. The probject is currently at the data cleaning stage, and I may add some other data to the project. So far, I am using about 3GB of data.

library(tidyverse)
library(sf)
library(ggmap)
library(lwgeom)
#recorded violations associated with blight (e.g. unkempt properties)
blight_violations <- read_csv("./data/Blight_Violations_3_19_2018.csv", 
                              guess_max = 10^6)
Parsed with column specification:
cols(
  .default = col_character(),
  `Ticket ID` = col_integer(),
  `Violator ID` = col_integer(),
  `Violation Street Number` = col_integer(),
  `Hearing Time` = col_time(format = ""),
  `Violation Latitude` = col_double(),
  `Violation Longitude` = col_double()
)
See spec(...) for full column specifications.

|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   1%    1 MB
|=                                                                                         |   1%    1 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   2%    3 MB
|=                                                                                         |   2%    3 MB
|=                                                                                         |   2%    3 MB
|==                                                                                        |   2%    3 MB
|==                                                                                        |   2%    3 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   3%    5 MB
|==                                                                                        |   3%    5 MB
|==                                                                                        |   3%    5 MB
|==                                                                                        |   3%    5 MB
|===                                                                                       |   3%    5 MB
|===                                                                                       |   3%    5 MB
|===                                                                                       |   3%    5 MB
|===                                                                                       |   3%    5 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   4%    6 MB
|===                                                                                       |   4%    6 MB
|===                                                                                       |   4%    7 MB
|===                                                                                       |   4%    7 MB
|===                                                                                       |   4%    7 MB
|===                                                                                       |   4%    7 MB
|====                                                                                      |   4%    7 MB
|====                                                                                      |   4%    7 MB
|====                                                                                      |   4%    7 MB
|====                                                                                      |   4%    7 MB
|====                                                                                      |   4%    7 MB
|====                                                                                      |   4%    8 MB
|====                                                                                      |   4%    8 MB
|====                                                                                      |   4%    8 MB
|====                                                                                      |   4%    8 MB
|====                                                                                      |   5%    8 MB
|====                                                                                      |   5%    8 MB
|====                                                                                      |   5%    8 MB
|====                                                                                      |   5%    8 MB
|====                                                                                      |   5%    8 MB
|====                                                                                      |   5%    9 MB
|====                                                                                      |   5%    9 MB
|====                                                                                      |   5%    9 MB
|=====                                                                                     |   5%    9 MB
|=====                                                                                     |   5%    9 MB
|=====                                                                                     |   5%    9 MB
|=====                                                                                     |   5%    9 MB
|=====                                                                                     |   5%    9 MB
|=====                                                                                     |   5%    9 MB
|=====                                                                                     |   5%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   11 MB
|=====                                                                                     |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   13 MB
|=======                                                                                   |   7%   13 MB
|=======                                                                                   |   7%   13 MB
|=======                                                                                   |   7%   13 MB
|=======                                                                                   |   7%   13 MB
|=======                                                                                   |   7%   13 MB
|=======                                                                                   |   8%   13 MB
|=======                                                                                   |   8%   13 MB
|=======                                                                                   |   8%   13 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|========                                                                                  |   8%   14 MB
|========                                                                                  |   8%   15 MB
|========                                                                                  |   8%   15 MB
|========                                                                                  |   9%   15 MB
|========                                                                                  |   9%   15 MB
|========                                                                                  |   9%   15 MB
|========                                                                                  |   9%   15 MB
|========                                                                                  |   9%   15 MB
|========                                                                                  |   9%   15 MB
|========                                                                                  |   9%   16 MB
|========                                                                                  |   9%   16 MB
|========                                                                                  |   9%   16 MB
|========                                                                                  |   9%   16 MB
|========                                                                                  |   9%   16 MB
|========                                                                                  |   9%   16 MB
|========                                                                                  |   9%   16 MB
|=========                                                                                 |   9%   16 MB
|=========                                                                                 |   9%   16 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   18 MB
|=========                                                                                 |  10%   18 MB
|=========                                                                                 |  10%   18 MB
|=========                                                                                 |  10%   18 MB
|=========                                                                                 |  10%   18 MB
|=========                                                                                 |  10%   18 MB
|==========                                                                                |  11%   18 MB
|==========                                                                                |  11%   18 MB
|==========                                                                                |  11%   18 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   20 MB
|==========                                                                                |  11%   20 MB
|==========                                                                                |  11%   20 MB
|==========                                                                                |  12%   20 MB
|==========                                                                                |  12%   20 MB
|===========                                                                               |  12%   20 MB
|===========                                                                               |  12%   20 MB
|===========                                                                               |  12%   20 MB
|===========                                                                               |  12%   20 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   22 MB
|===========                                                                               |  13%   22 MB
|===========                                                                               |  13%   22 MB
|===========                                                                               |  13%   22 MB
|============                                                                              |  13%   22 MB
|============                                                                              |  13%   22 MB
|============                                                                              |  13%   22 MB
|============                                                                              |  13%   22 MB
|============                                                                              |  13%   22 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  14%   23 MB
|============                                                                              |  14%   23 MB
|============                                                                              |  14%   24 MB
|============                                                                              |  14%   24 MB
|============                                                                              |  14%   24 MB
|=============                                                                             |  14%   24 MB
|=============                                                                             |  14%   24 MB
|=============                                                                             |  14%   24 MB
|=============                                                                             |  14%   24 MB
|=============                                                                             |  14%   24 MB
|=============                                                                             |  14%   24 MB
|=============                                                                             |  14%   25 MB
|=============                                                                             |  14%   25 MB
|=============                                                                             |  14%   25 MB
|=============                                                                             |  14%   25 MB
|=============                                                                             |  14%   25 MB
|=============                                                                             |  15%   25 MB
|=============                                                                             |  15%   25 MB
|=============                                                                             |  15%   25 MB
|=============                                                                             |  15%   25 MB
|=============                                                                             |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   27 MB
|==============                                                                            |  15%   27 MB
|==============                                                                            |  16%   27 MB
|==============                                                                            |  16%   27 MB
|==============                                                                            |  16%   27 MB
|==============                                                                            |  16%   27 MB
|==============                                                                            |  16%   27 MB
|==============                                                                            |  16%   27 MB
|==============                                                                            |  16%   27 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  17%   28 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|================                                                                          |  17%   29 MB
|================                                                                          |  17%   30 MB
|================                                                                          |  17%   30 MB
|================                                                                          |  17%   30 MB
|================                                                                          |  17%   30 MB
|================                                                                          |  17%   30 MB
|================                                                                          |  17%   30 MB
|================                                                                          |  18%   30 MB
|================                                                                          |  18%   30 MB
|================                                                                          |  18%   30 MB
|================                                                                          |  18%   31 MB
|================                                                                          |  18%   31 MB
|================                                                                          |  18%   31 MB
|================                                                                          |  18%   31 MB
|================                                                                          |  18%   31 MB
|================                                                                          |  18%   31 MB
|================                                                                          |  18%   31 MB
|=================                                                                         |  18%   31 MB
|=================                                                                         |  18%   31 MB
|=================                                                                         |  18%   32 MB
|=================                                                                         |  18%   32 MB
|=================                                                                         |  18%   32 MB
|=================                                                                         |  19%   32 MB
|=================                                                                         |  19%   32 MB
|=================                                                                         |  19%   32 MB
|=================                                                                         |  19%   32 MB
|=================                                                                         |  19%   32 MB
|=================                                                                         |  19%   32 MB
|=================                                                                         |  19%   33 MB
|=================                                                                         |  19%   33 MB
|=================                                                                         |  19%   33 MB
|=================                                                                         |  19%   33 MB
|=================                                                                         |  19%   33 MB
|=================                                                                         |  19%   33 MB
|==================                                                                        |  19%   33 MB
|==================                                                                        |  19%   33 MB
|==================                                                                        |  19%   33 MB
|==================                                                                        |  19%   33 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   35 MB
|==================                                                                        |  20%   35 MB
|==================                                                                        |  20%   35 MB
|==================                                                                        |  20%   35 MB
|===================                                                                       |  20%   35 MB
|===================                                                                       |  20%   35 MB
|===================                                                                       |  21%   35 MB
|===================                                                                       |  21%   35 MB
|===================                                                                       |  21%   35 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   37 MB
|===================                                                                       |  21%   37 MB
|===================                                                                       |  21%   37 MB
|====================                                                                      |  22%   37 MB
|====================                                                                      |  22%   37 MB
|====================                                                                      |  22%   37 MB
|====================                                                                      |  22%   37 MB
|====================                                                                      |  22%   37 MB
|====================                                                                      |  22%   37 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   39 MB
|====================                                                                      |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  24%   40 MB
|=====================                                                                     |  24%   40 MB
|=====================                                                                     |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   42 MB
|======================                                                                    |  24%   42 MB
|======================                                                                    |  24%   42 MB
|======================                                                                    |  24%   42 MB
|======================                                                                    |  24%   42 MB
|======================                                                                    |  25%   42 MB
|======================                                                                    |  25%   42 MB
|======================                                                                    |  25%   42 MB
|======================                                                                    |  25%   42 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   44 MB
|=======================                                                                   |  25%   44 MB
|=======================                                                                   |  26%   44 MB
|=======================                                                                   |  26%   44 MB
|=======================                                                                   |  26%   44 MB
|=======================                                                                   |  26%   44 MB
|=======================                                                                   |  26%   44 MB
|=======================                                                                   |  26%   44 MB
|========================                                                                  |  26%   44 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  27%   46 MB
|========================                                                                  |  27%   46 MB
|========================                                                                  |  27%   46 MB
|========================                                                                  |  27%   46 MB
|========================                                                                  |  27%   46 MB
|========================                                                                  |  27%   46 MB
|========================                                                                  |  27%   46 MB
|=========================                                                                 |  27%   46 MB
|=========================                                                                 |  27%   46 MB
|=========================                                                                 |  27%   47 MB
|=========================                                                                 |  27%   47 MB
|=========================                                                                 |  27%   47 MB
|=========================                                                                 |  27%   47 MB
|=========================                                                                 |  27%   47 MB
|=========================                                                                 |  27%   47 MB
|=========================                                                                 |  28%   47 MB
|=========================                                                                 |  28%   47 MB
|=========================                                                                 |  28%   47 MB
|=========================                                                                 |  28%   48 MB
|=========================                                                                 |  28%   48 MB
|=========================                                                                 |  28%   48 MB
|=========================                                                                 |  28%   48 MB
|=========================                                                                 |  28%   48 MB
|==========================                                                                |  28%   48 MB
|==========================                                                                |  28%   48 MB
|==========================                                                                |  28%   48 MB
|==========================                                                                |  28%   48 MB
|==========================                                                                |  28%   49 MB
|==========================                                                                |  28%   49 MB
|==========================                                                                |  28%   49 MB
|==========================                                                                |  29%   49 MB
|==========================                                                                |  29%   49 MB
|==========================                                                                |  29%   49 MB
|==========================                                                                |  29%   49 MB
|==========================                                                                |  29%   49 MB
|==========================                                                                |  29%   49 MB
|==========================                                                                |  29%   50 MB
|==========================                                                                |  29%   50 MB
|==========================                                                                |  29%   50 MB
|==========================                                                                |  29%   50 MB
|===========================                                                               |  29%   50 MB
|===========================                                                               |  29%   50 MB
|===========================                                                               |  29%   50 MB
|===========================                                                               |  29%   50 MB
|===========================                                                               |  29%   50 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   52 MB
|===========================                                                               |  30%   52 MB
|===========================                                                               |  30%   52 MB
|============================                                                              |  30%   52 MB
|============================                                                              |  30%   52 MB
|============================                                                              |  30%   52 MB
|============================                                                              |  31%   52 MB
|============================                                                              |  31%   52 MB
|============================                                                              |  31%   52 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   54 MB
|=============================                                                             |  31%   54 MB
|=============================                                                             |  31%   54 MB
|=============================                                                             |  32%   54 MB
|=============================                                                             |  32%   54 MB
|=============================                                                             |  32%   54 MB
|=============================                                                             |  32%   54 MB
|=============================                                                             |  32%   54 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  34%   57 MB
|===============================                                                           |  34%   57 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   59 MB
|===============================                                                           |  34%   59 MB
|===============================                                                           |  34%   59 MB
|===============================                                                           |  34%   59 MB
|===============================                                                           |  35%   59 MB
|===============================                                                           |  35%   59 MB
|===============================                                                           |  35%   59 MB
|================================                                                          |  35%   59 MB
|================================                                                          |  35%   59 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   61 MB
|================================                                                          |  35%   61 MB
|================================                                                          |  36%   61 MB
|================================                                                          |  36%   61 MB
|================================                                                          |  36%   61 MB
|================================                                                          |  36%   61 MB
|=================================                                                         |  36%   61 MB
|=================================                                                         |  36%   61 MB
|=================================                                                         |  36%   61 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  37%   62 MB
|=================================                                                         |  37%   63 MB
|=================================                                                         |  37%   63 MB
|=================================                                                         |  37%   63 MB
|=================================                                                         |  37%   63 MB
|==================================                                                        |  37%   63 MB
|==================================                                                        |  37%   63 MB
|==================================                                                        |  37%   63 MB
|==================================                                                        |  37%   63 MB
|==================================                                                        |  37%   63 MB
|==================================                                                        |  37%   64 MB
|==================================                                                        |  37%   64 MB
|==================================                                                        |  37%   64 MB
|==================================                                                        |  37%   64 MB
|==================================                                                        |  37%   64 MB
|==================================                                                        |  38%   64 MB
|==================================                                                        |  38%   64 MB
|==================================                                                        |  38%   64 MB
|==================================                                                        |  38%   64 MB
|==================================                                                        |  38%   65 MB
|==================================                                                        |  38%   65 MB
|==================================                                                        |  38%   65 MB
|===================================                                                       |  38%   65 MB
|===================================                                                       |  38%   65 MB
|===================================                                                       |  38%   65 MB
|===================================                                                       |  38%   65 MB
|===================================                                                       |  38%   65 MB
|===================================                                                       |  38%   66 MB
|===================================                                                       |  38%   66 MB
|===================================                                                       |  38%   66 MB
|===================================                                                       |  39%   66 MB
|===================================                                                       |  39%   66 MB
|===================================                                                       |  39%   66 MB
|===================================                                                       |  39%   66 MB
|===================================                                                       |  39%   66 MB
|===================================                                                       |  39%   66 MB
|===================================                                                       |  39%   67 MB
|===================================                                                       |  39%   67 MB
|===================================                                                       |  39%   67 MB
|====================================                                                      |  39%   67 MB
|====================================                                                      |  39%   67 MB
|====================================                                                      |  39%   67 MB
|====================================                                                      |  39%   67 MB
|====================================                                                      |  39%   67 MB
|====================================                                                      |  39%   67 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   69 MB
|=====================================                                                     |  40%   69 MB
|=====================================                                                     |  40%   69 MB
|=====================================                                                     |  40%   69 MB
|=====================================                                                     |  40%   69 MB
|=====================================                                                     |  40%   69 MB
|=====================================                                                     |  41%   69 MB
|=====================================                                                     |  41%   69 MB
|=====================================                                                     |  41%   69 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|======================================                                                    |  41%   71 MB
|======================================                                                    |  41%   71 MB
|======================================                                                    |  41%   71 MB
|======================================                                                    |  41%   71 MB
|======================================                                                    |  42%   71 MB
|======================================                                                    |  42%   71 MB
|======================================                                                    |  42%   71 MB
|======================================                                                    |  42%   71 MB
|======================================                                                    |  42%   71 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|=======================================                                                   |  42%   72 MB
|=======================================                                                   |  42%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   74 MB
|=======================================                                                   |  43%   74 MB
|=======================================                                                   |  43%   74 MB
|=======================================                                                   |  43%   74 MB
|=======================================                                                   |  43%   74 MB
|=======================================                                                   |  43%   74 MB
|========================================                                                  |  43%   74 MB
|========================================                                                  |  44%   74 MB
|========================================                                                  |  44%   74 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   76 MB
|========================================                                                  |  44%   76 MB
|========================================                                                  |  44%   76 MB
|========================================                                                  |  44%   76 MB
|========================================                                                  |  45%   76 MB
|=========================================                                                 |  45%   76 MB
|=========================================                                                 |  45%   76 MB
|=========================================                                                 |  45%   76 MB
|=========================================                                                 |  45%   76 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   78 MB
|=========================================                                                 |  45%   78 MB
|=========================================                                                 |  46%   78 MB
|=========================================                                                 |  46%   78 MB
|==========================================                                                |  46%   78 MB
|==========================================                                                |  46%   78 MB
|==========================================                                                |  46%   78 MB
|==========================================                                                |  46%   78 MB
|==========================================                                                |  46%   78 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  47%   80 MB
|==========================================                                                |  47%   80 MB
|==========================================                                                |  47%   80 MB
|===========================================                                               |  47%   80 MB
|===========================================                                               |  47%   80 MB
|===========================================                                               |  47%   80 MB
|===========================================                                               |  47%   80 MB
|===========================================                                               |  47%   80 MB
|===========================================                                               |  47%   80 MB
|===========================================                                               |  47%   81 MB
|===========================================                                               |  47%   81 MB
|===========================================                                               |  47%   81 MB
|===========================================                                               |  47%   81 MB
|===========================================                                               |  47%   81 MB
|===========================================                                               |  47%   81 MB
|===========================================                                               |  48%   81 MB
|===========================================                                               |  48%   81 MB
|===========================================                                               |  48%   81 MB
|===========================================                                               |  48%   82 MB
|===========================================                                               |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   83 MB
|============================================                                              |  48%   83 MB
|============================================                                              |  48%   83 MB
|============================================                                              |  49%   83 MB
|============================================                                              |  49%   83 MB
|============================================                                              |  49%   83 MB
|============================================                                              |  49%   83 MB
|============================================                                              |  49%   83 MB
|============================================                                              |  49%   83 MB
|============================================                                              |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|==============================================                                            |  50%   85 MB
|==============================================                                            |  50%   86 MB
|==============================================                                            |  50%   86 MB
|==============================================                                            |  50%   86 MB
|==============================================                                            |  50%   86 MB
|==============================================                                            |  50%   86 MB
|==============================================                                            |  50%   86 MB
|==============================================                                            |  51%   86 MB
|==============================================                                            |  51%   86 MB
|==============================================                                            |  51%   87 MB
|==============================================                                            |  51%   87 MB
|==============================================                                            |  51%   87 MB
|==============================================                                            |  51%   87 MB
|==============================================                                            |  51%   87 MB
|==============================================                                            |  51%   87 MB
|==============================================                                            |  51%   87 MB
|===============================================                                           |  51%   87 MB
|===============================================                                           |  51%   87 MB
|===============================================                                           |  51%   88 MB
|===============================================                                           |  51%   88 MB
|===============================================                                           |  51%   88 MB
|===============================================                                           |  51%   88 MB
|===============================================                                           |  52%   88 MB
|===============================================                                           |  52%   88 MB
|===============================================                                           |  52%   88 MB
|===============================================                                           |  52%   88 MB
|===============================================                                           |  52%   88 MB
|===============================================                                           |  52%   89 MB
|===============================================                                           |  52%   89 MB
|===============================================                                           |  52%   89 MB
|===============================================                                           |  52%   89 MB
|===============================================                                           |  52%   89 MB
|===============================================                                           |  52%   89 MB
|================================================                                          |  52%   89 MB
|================================================                                          |  52%   89 MB
|================================================                                          |  52%   89 MB
|================================================                                          |  52%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   91 MB
|================================================                                          |  53%   91 MB
|================================================                                          |  53%   91 MB
|================================================                                          |  53%   91 MB
|================================================                                          |  53%   91 MB
|=================================================                                         |  53%   91 MB
|=================================================                                         |  53%   91 MB
|=================================================                                         |  53%   91 MB
|=================================================                                         |  54%   91 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   93 MB
|=================================================                                         |  54%   93 MB
|=================================================                                         |  54%   93 MB
|=================================================                                         |  54%   93 MB
|==================================================                                        |  55%   93 MB
|==================================================                                        |  55%   93 MB
|==================================================                                        |  55%   93 MB
|==================================================                                        |  55%   93 MB
|==================================================                                        |  55%   93 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   95 MB
|==================================================                                        |  56%   95 MB
|===================================================                                       |  56%   95 MB
|===================================================                                       |  56%   95 MB
|===================================================                                       |  56%   95 MB
|===================================================                                       |  56%   95 MB
|===================================================                                       |  56%   95 MB
|===================================================                                       |  56%   95 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  57%   96 MB
|===================================================                                       |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   98 MB
|====================================================                                      |  57%   98 MB
|====================================================                                      |  57%   98 MB
|====================================================                                      |  57%   98 MB
|====================================================                                      |  57%   98 MB
|====================================================                                      |  58%   98 MB
|====================================================                                      |  58%   98 MB
|====================================================                                      |  58%   98 MB
|====================================================                                      |  58%   98 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%  100 MB
|=====================================================                                     |  58%  100 MB
|=====================================================                                     |  58%  100 MB
|=====================================================                                     |  59%  100 MB
|=====================================================                                     |  59%  100 MB
|=====================================================                                     |  59%  100 MB
|=====================================================                                     |  59%  100 MB
|=====================================================                                     |  59%  100 MB
|======================================================                                    |  59%  100 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  60%  102 MB
|======================================================                                    |  60%  102 MB
|======================================================                                    |  60%  102 MB
|======================================================                                    |  60%  102 MB
|======================================================                                    |  60%  102 MB
|======================================================                                    |  60%  102 MB
|======================================================                                    |  60%  102 MB
|=======================================================                                   |  60%  102 MB
|=======================================================                                   |  60%  102 MB
|=======================================================                                   |  60%  103 MB
|=======================================================                                   |  60%  103 MB
|=======================================================                                   |  60%  103 MB
|=======================================================                                   |  60%  103 MB
|=======================================================                                   |  60%  103 MB
|=======================================================                                   |  60%  103 MB
|=======================================================                                   |  61%  103 MB
|=======================================================                                   |  61%  103 MB
|=======================================================                                   |  61%  103 MB
|=======================================================                                   |  61%  104 MB
|=======================================================                                   |  61%  104 MB
|=======================================================                                   |  61%  104 MB
|=======================================================                                   |  61%  104 MB
|=======================================================                                   |  61%  104 MB
|========================================================                                  |  61%  104 MB
|========================================================                                  |  61%  104 MB
|========================================================                                  |  61%  104 MB
|========================================================                                  |  61%  105 MB
|========================================================                                  |  61%  105 MB
|========================================================                                  |  61%  105 MB
|========================================================                                  |  61%  105 MB
|========================================================                                  |  62%  105 MB
|========================================================                                  |  62%  105 MB
|========================================================                                  |  62%  105 MB
|========================================================                                  |  62%  105 MB
|========================================================                                  |  62%  105 MB
|========================================================                                  |  62%  106 MB
|========================================================                                  |  62%  106 MB
|========================================================                                  |  62%  106 MB
|========================================================                                  |  62%  106 MB
|=========================================================                                 |  62%  106 MB
|=========================================================                                 |  62%  106 MB
|=========================================================                                 |  62%  106 MB
|=========================================================                                 |  62%  106 MB
|=========================================================                                 |  62%  106 MB
|=========================================================                                 |  62%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  108 MB
|=========================================================                                 |  63%  108 MB
|=========================================================                                 |  63%  108 MB
|=========================================================                                 |  63%  108 MB
|==========================================================                                |  63%  108 MB
|==========================================================                                |  63%  108 MB
|==========================================================                                |  63%  108 MB
|==========================================================                                |  63%  108 MB
|==========================================================                                |  64%  108 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  110 MB
|==========================================================                                |  64%  110 MB
|===========================================================                               |  64%  110 MB
|===========================================================                               |  64%  110 MB
|===========================================================                               |  65%  110 MB
|===========================================================                               |  65%  110 MB
|===========================================================                               |  65%  110 MB
|===========================================================                               |  65%  110 MB
|===========================================================                               |  65%  110 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  112 MB
|============================================================                              |  65%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|=============================================================                             |  67%  113 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  115 MB
|=============================================================                             |  67%  115 MB
|=============================================================                             |  67%  115 MB
|=============================================================                             |  67%  115 MB
|=============================================================                             |  67%  115 MB
|=============================================================                             |  68%  115 MB
|=============================================================                             |  68%  115 MB
|==============================================================                            |  68%  115 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  117 MB
|==============================================================                            |  68%  117 MB
|==============================================================                            |  68%  117 MB
|==============================================================                            |  69%  117 MB
|==============================================================                            |  69%  117 MB
|==============================================================                            |  69%  117 MB
|===============================================================                           |  69%  117 MB
|===============================================================                           |  69%  117 MB
|===============================================================                           |  69%  117 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  119 MB
|===============================================================                           |  70%  119 MB
|===============================================================                           |  70%  119 MB
|===============================================================                           |  70%  119 MB
|===============================================================                           |  70%  119 MB
|================================================================                          |  70%  119 MB
|================================================================                          |  70%  119 MB
|================================================================                          |  70%  119 MB
|================================================================                          |  70%  119 MB
|================================================================                          |  70%  120 MB
|================================================================                          |  70%  120 MB
|================================================================                          |  70%  120 MB
|================================================================                          |  70%  120 MB
|================================================================                          |  70%  120 MB
|================================================================                          |  70%  120 MB
|================================================================                          |  71%  120 MB
|================================================================                          |  71%  120 MB
|================================================================                          |  71%  120 MB
|================================================================                          |  71%  121 MB
|================================================================                          |  71%  121 MB
|================================================================                          |  71%  121 MB
|================================================================                          |  71%  121 MB
|=================================================================                         |  71%  121 MB
|=================================================================                         |  71%  121 MB
|=================================================================                         |  71%  121 MB
|=================================================================                         |  71%  121 MB
|=================================================================                         |  71%  121 MB
|=================================================================                         |  71%  122 MB
|=================================================================                         |  71%  122 MB
|=================================================================                         |  71%  122 MB
|=================================================================                         |  72%  122 MB
|=================================================================                         |  72%  122 MB
|=================================================================                         |  72%  122 MB
|=================================================================                         |  72%  122 MB
|=================================================================                         |  72%  122 MB
|=================================================================                         |  72%  123 MB
|=================================================================                         |  72%  123 MB
|=================================================================                         |  72%  123 MB
|==================================================================                        |  72%  123 MB
|==================================================================                        |  72%  123 MB
|==================================================================                        |  72%  123 MB
|==================================================================                        |  72%  123 MB
|==================================================================                        |  72%  123 MB
|==================================================================                        |  72%  123 MB
|==================================================================                        |  72%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  125 MB
|===================================================================                       |  73%  125 MB
|===================================================================                       |  73%  125 MB
|===================================================================                       |  73%  125 MB
|===================================================================                       |  73%  125 MB
|===================================================================                       |  73%  125 MB
|===================================================================                       |  73%  125 MB
|===================================================================                       |  74%  125 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  127 MB
|====================================================================                      |  74%  127 MB
|====================================================================                      |  74%  127 MB
|====================================================================                      |  74%  127 MB
|====================================================================                      |  74%  127 MB
|====================================================================                      |  75%  127 MB
|====================================================================                      |  75%  127 MB
|====================================================================                      |  75%  127 MB
|====================================================================                      |  75%  127 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|=====================================================================                     |  75%  128 MB
|=====================================================================                     |  75%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  130 MB
|=====================================================================                     |  76%  130 MB
|=====================================================================                     |  76%  130 MB
|=====================================================================                     |  76%  130 MB
|=====================================================================                     |  76%  130 MB
|=====================================================================                     |  76%  130 MB
|=====================================================================                     |  76%  130 MB
|======================================================================                    |  76%  130 MB
|======================================================================                    |  77%  130 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  132 MB
|======================================================================                    |  77%  132 MB
|======================================================================                    |  77%  132 MB
|======================================================================                    |  77%  132 MB
|======================================================================                    |  77%  132 MB
|=======================================================================                   |  78%  132 MB
|=======================================================================                   |  78%  132 MB
|=======================================================================                   |  78%  132 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  134 MB
|=======================================================================                   |  78%  134 MB
|=======================================================================                   |  78%  134 MB
|=======================================================================                   |  79%  134 MB
|=======================================================================                   |  79%  134 MB
|========================================================================                  |  79%  134 MB
|========================================================================                  |  79%  134 MB
|========================================================================                  |  79%  134 MB
|========================================================================                  |  79%  134 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  136 MB
|========================================================================                  |  80%  136 MB
|========================================================================                  |  80%  136 MB
|========================================================================                  |  80%  136 MB
|=========================================================================                 |  80%  136 MB
|=========================================================================                 |  80%  136 MB
|=========================================================================                 |  80%  136 MB
|=========================================================================                 |  80%  136 MB
|=========================================================================                 |  80%  136 MB
|=========================================================================                 |  80%  137 MB
|=========================================================================                 |  80%  137 MB
|=========================================================================                 |  80%  137 MB
|=========================================================================                 |  80%  137 MB
|=========================================================================                 |  80%  137 MB
|=========================================================================                 |  80%  137 MB
|=========================================================================                 |  81%  137 MB
|=========================================================================                 |  81%  137 MB
|=========================================================================                 |  81%  137 MB
|=========================================================================                 |  81%  138 MB
|=========================================================================                 |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  139 MB
|==========================================================================                |  81%  139 MB
|==========================================================================                |  81%  139 MB
|==========================================================================                |  82%  139 MB
|==========================================================================                |  82%  139 MB
|==========================================================================                |  82%  139 MB
|==========================================================================                |  82%  139 MB
|==========================================================================                |  82%  139 MB
|==========================================================================                |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  84%  142 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|=============================================================================             |  84%  143 MB
|=============================================================================             |  84%  144 MB
|=============================================================================             |  84%  144 MB
|=============================================================================             |  84%  144 MB
|=============================================================================             |  84%  144 MB
|=============================================================================             |  85%  144 MB
|=============================================================================             |  85%  144 MB
|=============================================================================             |  85%  144 MB
|=============================================================================             |  85%  144 MB
|=============================================================================             |  85%  144 MB
|=============================================================================             |  85%  145 MB
|=============================================================================             |  85%  145 MB
|=============================================================================             |  85%  145 MB
|=============================================================================             |  85%  145 MB
|=============================================================================             |  85%  145 MB
|=============================================================================             |  85%  145 MB
|==============================================================================            |  85%  145 MB
|==============================================================================            |  85%  145 MB
|==============================================================================            |  85%  145 MB
|==============================================================================            |  85%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  147 MB
|==============================================================================            |  86%  147 MB
|==============================================================================            |  86%  147 MB
|==============================================================================            |  86%  147 MB
|==============================================================================            |  86%  147 MB
|===============================================================================           |  86%  147 MB
|===============================================================================           |  86%  147 MB
|===============================================================================           |  86%  147 MB
|===============================================================================           |  87%  147 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  149 MB
|===============================================================================           |  87%  149 MB
|===============================================================================           |  87%  149 MB
|===============================================================================           |  87%  149 MB
|===============================================================================           |  87%  149 MB
|================================================================================          |  87%  149 MB
|================================================================================          |  88%  149 MB
|================================================================================          |  88%  149 MB
|================================================================================          |  88%  149 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  151 MB
|================================================================================          |  88%  151 MB
|================================================================================          |  89%  151 MB
|=================================================================================         |  89%  151 MB
|=================================================================================         |  89%  151 MB
|=================================================================================         |  89%  151 MB
|=================================================================================         |  89%  151 MB
|=================================================================================         |  89%  151 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  90%  153 MB
|=================================================================================         |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  154 MB
|==================================================================================        |  90%  154 MB
|==================================================================================        |  90%  154 MB
|==================================================================================        |  90%  154 MB
|==================================================================================        |  90%  154 MB
|==================================================================================        |  90%  154 MB
|==================================================================================        |  91%  154 MB
|==================================================================================        |  91%  154 MB
|==================================================================================        |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  156 MB
|===================================================================================       |  91%  156 MB
|===================================================================================       |  91%  156 MB
|===================================================================================       |  92%  156 MB
|===================================================================================       |  92%  156 MB
|===================================================================================       |  92%  156 MB
|===================================================================================       |  92%  156 MB
|===================================================================================       |  92%  156 MB
|====================================================================================      |  92%  156 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  158 MB
|====================================================================================      |  93%  158 MB
|====================================================================================      |  93%  158 MB
|====================================================================================      |  93%  158 MB
|====================================================================================      |  93%  158 MB
|====================================================================================      |  93%  158 MB
|====================================================================================      |  93%  158 MB
|=====================================================================================     |  93%  158 MB
|=====================================================================================     |  93%  158 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  94%  159 MB
|=====================================================================================     |  94%  160 MB
|=====================================================================================     |  94%  160 MB
|=====================================================================================     |  94%  160 MB
|=====================================================================================     |  94%  160 MB
|=====================================================================================     |  94%  160 MB
|=====================================================================================     |  94%  160 MB
|======================================================================================    |  94%  160 MB
|======================================================================================    |  94%  160 MB
|======================================================================================    |  94%  160 MB
|======================================================================================    |  94%  161 MB
|======================================================================================    |  94%  161 MB
|======================================================================================    |  94%  161 MB
|======================================================================================    |  94%  161 MB
|======================================================================================    |  95%  161 MB
|======================================================================================    |  95%  161 MB
|======================================================================================    |  95%  161 MB
|======================================================================================    |  95%  161 MB
|======================================================================================    |  95%  162 MB
|======================================================================================    |  95%  162 MB
|======================================================================================    |  95%  162 MB
|======================================================================================    |  95%  162 MB
|======================================================================================    |  95%  162 MB
|=======================================================================================   |  95%  162 MB
|=======================================================================================   |  95%  162 MB
|=======================================================================================   |  95%  162 MB
|=======================================================================================   |  95%  162 MB
|=======================================================================================   |  95%  163 MB
|=======================================================================================   |  95%  163 MB
|=======================================================================================   |  96%  163 MB
|=======================================================================================   |  96%  163 MB
|=======================================================================================   |  96%  163 MB
|=======================================================================================   |  96%  163 MB
|=======================================================================================   |  96%  163 MB
|=======================================================================================   |  96%  163 MB
|=======================================================================================   |  96%  164 MB
|=======================================================================================   |  96%  164 MB
|=======================================================================================   |  96%  164 MB
|=======================================================================================   |  96%  164 MB
|========================================================================================  |  96%  164 MB
|========================================================================================  |  96%  164 MB
|========================================================================================  |  96%  164 MB
|========================================================================================  |  96%  164 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  166 MB
|========================================================================================  |  97%  166 MB
|========================================================================================= |  97%  166 MB
|========================================================================================= |  97%  166 MB
|========================================================================================= |  97%  166 MB
|========================================================================================= |  98%  166 MB
|========================================================================================= |  98%  166 MB
|========================================================================================= |  98%  166 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  168 MB
|========================================================================================= |  98%  168 MB
|==========================================================================================|  98%  168 MB
|==========================================================================================|  99%  168 MB
|==========================================================================================|  99%  168 MB
|==========================================================================================|  99%  168 MB
|==========================================================================================|  99%  168 MB
|==========================================================================================|  99%  168 MB
|==========================================================================================|  99%  168 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|===========================================================================================| 100%  170 MB
#read the downloaded file for all the building permits and then filter out the permits for dismantling
dismantle_permits <- read_csv("./data/Building_Permits_3_19_2018.csv", 
                             guess_max = 10^6) %>%
  filter(`Building Permit Type` == "Dismantle")
Parsed with column specification:
cols(
  .default = col_character(),
  `Parcel Size` = col_double(),
  `Parcel Cluster Sector` = col_integer(),
  Stories = col_double(),
  `Parcel Floor Area` = col_integer(),
  `Parcel Ground Area` = col_integer(),
  `Sequence Number` = col_integer()
)
See spec(...) for full column specifications.
  
#the files that contain the crime data
crime_to_12062016 <- 
  read_csv("./data/DPD__All_Crime_Incidents__January_1__2009_-_December_6__2016.csv",
           guess_max = 10^6)
Parsed with column specification:
cols(
  ROWNUM = col_integer(),
  CASEID = col_integer(),
  CRIMEID = col_integer(),
  CRNO = col_character(),
  CATEGORY = col_character(),
  OFFENSEDESCRIPTION = col_character(),
  STATEOFFENSEFILECLASS = col_integer(),
  INCIDENTDATE = col_character(),
  HOUR = col_integer(),
  SCA = col_integer(),
  PRECINCT = col_integer(),
  COUNCIL = col_character(),
  NEIGHBORHOOD = col_character(),
  CENSUSTRACT = col_double(),
  LOCATION = col_character()
)

|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    2 MB
|                                                                                          |   0%    2 MB
|                                                                                          |   1%    2 MB
|                                                                                          |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    4 MB
|=                                                                                         |   1%    4 MB
|=                                                                                         |   1%    4 MB
|=                                                                                         |   1%    4 MB
|=                                                                                         |   1%    4 MB
|=                                                                                         |   2%    4 MB
|=                                                                                         |   2%    4 MB
|=                                                                                         |   2%    4 MB
|=                                                                                         |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   3%    6 MB
|==                                                                                        |   3%    7 MB
|==                                                                                        |   3%    7 MB
|==                                                                                        |   3%    7 MB
|==                                                                                        |   3%    7 MB
|==                                                                                        |   3%    7 MB
|===                                                                                       |   3%    7 MB
|===                                                                                       |   3%    7 MB
|===                                                                                       |   3%    7 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    9 MB
|===                                                                                       |   3%    9 MB
|===                                                                                       |   4%    9 MB
|===                                                                                       |   4%    9 MB
|===                                                                                       |   4%    9 MB
|===                                                                                       |   4%    9 MB
|===                                                                                       |   4%    9 MB
|===                                                                                       |   4%    9 MB
|===                                                                                       |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   11 MB
|====                                                                                      |   4%   11 MB
|====                                                                                      |   4%   11 MB
|====                                                                                      |   4%   11 MB
|====                                                                                      |   5%   11 MB
|====                                                                                      |   5%   11 MB
|====                                                                                      |   5%   11 MB
|====                                                                                      |   5%   11 MB
|====                                                                                      |   5%   12 MB
|====                                                                                      |   5%   12 MB
|====                                                                                      |   5%   12 MB
|====                                                                                      |   5%   12 MB
|====                                                                                      |   5%   12 MB
|=====                                                                                     |   5%   12 MB
|=====                                                                                     |   5%   12 MB
|=====                                                                                     |   5%   12 MB
|=====                                                                                     |   5%   13 MB
|=====                                                                                     |   5%   13 MB
|=====                                                                                     |   5%   13 MB
|=====                                                                                     |   5%   13 MB
|=====                                                                                     |   5%   13 MB
|=====                                                                                     |   5%   13 MB
|=====                                                                                     |   6%   13 MB
|=====                                                                                     |   6%   13 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   17 MB
|======                                                                                    |   7%   17 MB
|======                                                                                    |   7%   17 MB
|======                                                                                    |   7%   17 MB
|=======                                                                                   |   7%   17 MB
|=======                                                                                   |   7%   17 MB
|=======                                                                                   |   7%   17 MB
|=======                                                                                   |   7%   18 MB
|=======                                                                                   |   7%   18 MB
|=======                                                                                   |   7%   18 MB
|=======                                                                                   |   8%   18 MB
|=======                                                                                   |   8%   18 MB
|=======                                                                                   |   8%   18 MB
|=======                                                                                   |   8%   18 MB
|=======                                                                                   |   8%   18 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   20 MB
|========                                                                                  |   8%   20 MB
|========                                                                                  |   8%   20 MB
|========                                                                                  |   8%   20 MB
|========                                                                                  |   8%   20 MB
|========                                                                                  |   9%   20 MB
|========                                                                                  |   9%   20 MB
|========                                                                                  |   9%   20 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   22 MB
|========                                                                                  |   9%   22 MB
|========                                                                                  |   9%   22 MB
|========                                                                                  |   9%   22 MB
|========                                                                                  |   9%   22 MB
|=========                                                                                 |   9%   22 MB
|=========                                                                                 |   9%   22 MB
|=========                                                                                 |  10%   22 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   25 MB
|==========                                                                                |  11%   25 MB
|==========                                                                                |  11%   25 MB
|==========                                                                                |  11%   25 MB
|==========                                                                                |  11%   25 MB
|==========                                                                                |  11%   25 MB
|==========                                                                                |  11%   25 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   27 MB
|==========                                                                                |  11%   27 MB
|==========                                                                                |  11%   27 MB
|==========                                                                                |  11%   27 MB
|==========                                                                                |  12%   27 MB
|==========                                                                                |  12%   27 MB
|===========                                                                               |  12%   27 MB
|===========                                                                               |  12%   27 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   29 MB
|===========                                                                               |  12%   29 MB
|===========                                                                               |  12%   29 MB
|===========                                                                               |  12%   29 MB
|===========                                                                               |  12%   29 MB
|===========                                                                               |  12%   29 MB
|===========                                                                               |  13%   29 MB
|===========                                                                               |  13%   29 MB
|===========                                                                               |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  14%   32 MB
|============                                                                              |  14%   32 MB
|============                                                                              |  14%   32 MB
|============                                                                              |  14%   32 MB
|============                                                                              |  14%   32 MB
|=============                                                                             |  14%   32 MB
|=============                                                                             |  14%   32 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   34 MB
|=============                                                                             |  14%   34 MB
|=============                                                                             |  14%   34 MB
|=============                                                                             |  15%   34 MB
|=============                                                                             |  15%   34 MB
|=============                                                                             |  15%   34 MB
|=============                                                                             |  15%   34 MB
|=============                                                                             |  15%   34 MB
|=============                                                                             |  15%   35 MB
|=============                                                                             |  15%   35 MB
|==============                                                                            |  15%   35 MB
|==============                                                                            |  15%   35 MB
|==============                                                                            |  15%   35 MB
|==============                                                                            |  15%   35 MB
|==============                                                                            |  15%   35 MB
|==============                                                                            |  15%   35 MB
|==============                                                                            |  15%   36 MB
|==============                                                                            |  15%   36 MB
|==============                                                                            |  15%   36 MB
|==============                                                                            |  15%   36 MB
|==============                                                                            |  15%   36 MB
|==============                                                                            |  16%   36 MB
|==============                                                                            |  16%   36 MB
|==============                                                                            |  16%   36 MB
|==============                                                                            |  16%   37 MB
|==============                                                                            |  16%   37 MB
|==============                                                                            |  16%   37 MB
|==============                                                                            |  16%   37 MB
|==============                                                                            |  16%   37 MB
|==============                                                                            |  16%   37 MB
|===============                                                                           |  16%   37 MB
|===============                                                                           |  16%   37 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   40 MB
|===============                                                                           |  17%   40 MB
|================                                                                          |  17%   40 MB
|================                                                                          |  17%   40 MB
|================                                                                          |  17%   40 MB
|================                                                                          |  17%   40 MB
|================                                                                          |  17%   40 MB
|================                                                                          |  17%   40 MB
|================                                                                          |  17%   41 MB
|================                                                                          |  17%   41 MB
|================                                                                          |  18%   41 MB
|================                                                                          |  18%   41 MB
|================                                                                          |  18%   41 MB
|================                                                                          |  18%   41 MB
|================                                                                          |  18%   41 MB
|================                                                                          |  18%   41 MB
|================                                                                          |  18%   42 MB
|================                                                                          |  18%   42 MB
|================                                                                          |  18%   42 MB
|================                                                                          |  18%   42 MB
|================                                                                          |  18%   42 MB
|================                                                                          |  18%   42 MB
|=================                                                                         |  18%   42 MB
|=================                                                                         |  18%   43 MB
|=================                                                                         |  18%   43 MB
|=================                                                                         |  18%   43 MB
|=================                                                                         |  18%   43 MB
|=================                                                                         |  18%   43 MB
|=================                                                                         |  19%   43 MB
|=================                                                                         |  19%   43 MB
|=================                                                                         |  19%   43 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   45 MB
|=================                                                                         |  19%   45 MB
|=================                                                                         |  19%   45 MB
|==================                                                                        |  19%   45 MB
|==================                                                                        |  19%   45 MB
|==================                                                                        |  19%   45 MB
|==================                                                                        |  19%   45 MB
|==================                                                                        |  20%   45 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   47 MB
|==================                                                                        |  20%   47 MB
|==================                                                                        |  20%   47 MB
|==================                                                                        |  20%   47 MB
|==================                                                                        |  20%   47 MB
|==================                                                                        |  20%   47 MB
|==================                                                                        |  20%   47 MB
|===================                                                                       |  20%   47 MB
|===================                                                                       |  20%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   50 MB
|===================                                                                       |  21%   50 MB
|====================                                                                      |  21%   50 MB
|====================                                                                      |  22%   50 MB
|====================                                                                      |  22%   50 MB
|====================                                                                      |  22%   50 MB
|====================                                                                      |  22%   50 MB
|====================                                                                      |  22%   50 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   52 MB
|====================                                                                      |  22%   52 MB
|====================                                                                      |  22%   52 MB
|====================                                                                      |  22%   52 MB
|====================                                                                      |  22%   52 MB
|====================                                                                      |  22%   52 MB
|====================                                                                      |  23%   52 MB
|=====================                                                                     |  23%   52 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  24%   55 MB
|=====================                                                                     |  24%   55 MB
|=====================                                                                     |  24%   55 MB
|======================                                                                    |  24%   55 MB
|======================                                                                    |  24%   55 MB
|======================                                                                    |  24%   55 MB
|======================                                                                    |  24%   55 MB
|======================                                                                    |  24%   55 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   57 MB
|======================                                                                    |  24%   57 MB
|======================                                                                    |  25%   57 MB
|======================                                                                    |  25%   57 MB
|======================                                                                    |  25%   57 MB
|======================                                                                    |  25%   57 MB
|======================                                                                    |  25%   57 MB
|=======================                                                                   |  25%   57 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   59 MB
|=======================                                                                   |  25%   59 MB
|=======================                                                                   |  25%   59 MB
|=======================                                                                   |  25%   59 MB
|=======================                                                                   |  26%   59 MB
|=======================                                                                   |  26%   59 MB
|=======================                                                                   |  26%   59 MB
|=======================                                                                   |  26%   59 MB
|=======================                                                                   |  26%   60 MB
|=======================                                                                   |  26%   60 MB
|=======================                                                                   |  26%   60 MB
|========================                                                                  |  26%   60 MB
|========================                                                                  |  26%   60 MB
|========================                                                                  |  26%   60 MB
|========================                                                                  |  26%   60 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  27%   61 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   65 MB
|=========================                                                                 |  28%   65 MB
|=========================                                                                 |  28%   65 MB
|=========================                                                                 |  28%   65 MB
|==========================                                                                |  28%   65 MB
|==========================                                                                |  28%   65 MB
|==========================                                                                |  28%   65 MB
|==========================                                                                |  28%   65 MB
|==========================                                                                |  28%   66 MB
|==========================                                                                |  28%   66 MB
|==========================                                                                |  28%   66 MB
|==========================                                                                |  29%   66 MB
|==========================                                                                |  29%   66 MB
|==========================                                                                |  29%   66 MB
|==========================                                                                |  29%   66 MB
|==========================                                                                |  29%   66 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|===========================                                                               |  29%   68 MB
|===========================                                                               |  29%   68 MB
|===========================                                                               |  29%   68 MB
|===========================                                                               |  29%   68 MB
|===========================                                                               |  29%   68 MB
|===========================                                                               |  29%   68 MB
|===========================                                                               |  30%   68 MB
|===========================                                                               |  30%   68 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   70 MB
|===========================                                                               |  30%   70 MB
|===========================                                                               |  30%   70 MB
|===========================                                                               |  30%   70 MB
|============================                                                              |  30%   70 MB
|============================                                                              |  30%   70 MB
|============================                                                              |  30%   70 MB
|============================                                                              |  30%   70 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|=============================                                                             |  31%   73 MB
|=============================                                                             |  31%   73 MB
|=============================                                                             |  32%   73 MB
|=============================                                                             |  32%   73 MB
|=============================                                                             |  32%   73 MB
|=============================                                                             |  32%   73 MB
|=============================                                                             |  32%   73 MB
|=============================                                                             |  32%   73 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   75 MB
|=============================                                                             |  32%   75 MB
|=============================                                                             |  32%   75 MB
|=============================                                                             |  32%   75 MB
|==============================                                                            |  32%   75 MB
|==============================                                                            |  33%   75 MB
|==============================                                                            |  33%   75 MB
|==============================                                                            |  33%   75 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  34%   77 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   80 MB
|===============================                                                           |  34%   80 MB
|===============================                                                           |  35%   80 MB
|===============================                                                           |  35%   80 MB
|===============================                                                           |  35%   80 MB
|================================                                                          |  35%   80 MB
|================================                                                          |  35%   80 MB
|================================                                                          |  35%   80 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   82 MB
|================================                                                          |  35%   82 MB
|================================                                                          |  35%   82 MB
|================================                                                          |  35%   82 MB
|================================                                                          |  36%   82 MB
|================================                                                          |  36%   82 MB
|================================                                                          |  36%   82 MB
|================================                                                          |  36%   82 MB
|================================                                                          |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   84 MB
|=================================                                                         |  36%   84 MB
|=================================                                                         |  36%   84 MB
|=================================                                                         |  36%   84 MB
|=================================                                                         |  36%   84 MB
|=================================                                                         |  36%   84 MB
|=================================                                                         |  37%   84 MB
|=================================                                                         |  37%   84 MB
|=================================                                                         |  37%   85 MB
|=================================                                                         |  37%   85 MB
|=================================                                                         |  37%   85 MB
|=================================                                                         |  37%   85 MB
|=================================                                                         |  37%   85 MB
|==================================                                                        |  37%   85 MB
|==================================                                                        |  37%   85 MB
|==================================                                                        |  37%   85 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   89 MB
|===================================                                                       |  38%   89 MB
|===================================                                                       |  38%   89 MB
|===================================                                                       |  39%   89 MB
|===================================                                                       |  39%   89 MB
|===================================                                                       |  39%   89 MB
|===================================                                                       |  39%   89 MB
|===================================                                                       |  39%   89 MB
|===================================                                                       |  39%   90 MB
|===================================                                                       |  39%   90 MB
|===================================                                                       |  39%   90 MB
|===================================                                                       |  39%   90 MB
|===================================                                                       |  39%   90 MB
|====================================                                                      |  39%   90 MB
|====================================                                                      |  39%   90 MB
|====================================                                                      |  39%   90 MB
|====================================                                                      |  39%   91 MB
|====================================                                                      |  39%   91 MB
|====================================                                                      |  39%   91 MB
|====================================                                                      |  39%   91 MB
|====================================                                                      |  39%   91 MB
|====================================                                                      |  40%   91 MB
|====================================                                                      |  40%   91 MB
|====================================                                                      |  40%   91 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   95 MB
|=====================================                                                     |  41%   95 MB
|=====================================                                                     |  41%   95 MB
|=====================================                                                     |  41%   95 MB
|=====================================                                                     |  41%   95 MB
|=====================================                                                     |  41%   95 MB
|======================================                                                    |  41%   95 MB
|======================================                                                    |  41%   95 MB
|======================================                                                    |  41%   96 MB
|======================================                                                    |  41%   96 MB
|======================================                                                    |  42%   96 MB
|======================================                                                    |  42%   96 MB
|======================================                                                    |  42%   96 MB
|======================================                                                    |  42%   96 MB
|======================================                                                    |  42%   96 MB
|======================================                                                    |  42%   96 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   98 MB
|======================================                                                    |  42%   98 MB
|=======================================                                                   |  42%   98 MB
|=======================================                                                   |  42%   98 MB
|=======================================                                                   |  43%   98 MB
|=======================================                                                   |  43%   98 MB
|=======================================                                                   |  43%   98 MB
|=======================================                                                   |  43%   98 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%  100 MB
|=======================================                                                   |  43%  100 MB
|=======================================                                                   |  43%  100 MB
|=======================================                                                   |  43%  100 MB
|=======================================                                                   |  43%  100 MB
|=======================================                                                   |  43%  100 MB
|========================================                                                  |  43%  100 MB
|========================================                                                  |  44%  100 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  103 MB
|========================================                                                  |  45%  103 MB
|=========================================                                                 |  45%  103 MB
|=========================================                                                 |  45%  103 MB
|=========================================                                                 |  45%  103 MB
|=========================================                                                 |  45%  103 MB
|=========================================                                                 |  45%  103 MB
|=========================================                                                 |  45%  103 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  105 MB
|=========================================                                                 |  45%  105 MB
|=========================================                                                 |  45%  105 MB
|=========================================                                                 |  46%  105 MB
|=========================================                                                 |  46%  105 MB
|=========================================                                                 |  46%  105 MB
|==========================================                                                |  46%  105 MB
|==========================================                                                |  46%  105 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  107 MB
|==========================================                                                |  46%  107 MB
|==========================================                                                |  46%  107 MB
|==========================================                                                |  46%  107 MB
|==========================================                                                |  46%  107 MB
|==========================================                                                |  46%  107 MB
|==========================================                                                |  47%  107 MB
|==========================================                                                |  47%  107 MB
|==========================================                                                |  47%  108 MB
|==========================================                                                |  47%  108 MB
|===========================================                                               |  47%  108 MB
|===========================================                                               |  47%  108 MB
|===========================================                                               |  47%  108 MB
|===========================================                                               |  47%  108 MB
|===========================================                                               |  47%  108 MB
|===========================================                                               |  47%  108 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  48%  110 MB
|===========================================                                               |  48%  110 MB
|===========================================                                               |  48%  110 MB
|===========================================                                               |  48%  110 MB
|===========================================                                               |  48%  110 MB
|===========================================                                               |  48%  110 MB
|============================================                                              |  48%  110 MB
|============================================                                              |  48%  110 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  112 MB
|============================================                                              |  48%  112 MB
|============================================                                              |  49%  112 MB
|============================================                                              |  49%  112 MB
|============================================                                              |  49%  112 MB
|============================================                                              |  49%  112 MB
|============================================                                              |  49%  112 MB
|============================================                                              |  49%  112 MB
|============================================                                              |  49%  113 MB
|============================================                                              |  49%  113 MB
|=============================================                                             |  49%  113 MB
|=============================================                                             |  49%  113 MB
|=============================================                                             |  49%  113 MB
|=============================================                                             |  49%  113 MB
|=============================================                                             |  49%  113 MB
|=============================================                                             |  49%  113 MB
|=============================================                                             |  49%  114 MB
|=============================================                                             |  49%  114 MB
|=============================================                                             |  49%  114 MB
|=============================================                                             |  49%  114 MB
|=============================================                                             |  50%  114 MB
|=============================================                                             |  50%  114 MB
|=============================================                                             |  50%  114 MB
|=============================================                                             |  50%  114 MB
|=============================================                                             |  50%  115 MB
|=============================================                                             |  50%  115 MB
|=============================================                                             |  50%  115 MB
|=============================================                                             |  50%  115 MB
|=============================================                                             |  50%  115 MB
|=============================================                                             |  50%  115 MB
|=============================================                                             |  50%  115 MB
|==============================================                                            |  50%  115 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  51%  116 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  118 MB
|==============================================                                            |  51%  118 MB
|===============================================                                           |  51%  118 MB
|===============================================                                           |  51%  118 MB
|===============================================                                           |  51%  118 MB
|===============================================                                           |  51%  118 MB
|===============================================                                           |  51%  118 MB
|===============================================                                           |  51%  118 MB
|===============================================                                           |  51%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  120 MB
|===============================================                                           |  52%  120 MB
|===============================================                                           |  52%  120 MB
|===============================================                                           |  52%  120 MB
|===============================================                                           |  52%  120 MB
|===============================================                                           |  52%  120 MB
|================================================                                          |  52%  120 MB
|================================================                                          |  52%  120 MB
|================================================                                          |  52%  121 MB
|================================================                                          |  52%  121 MB
|================================================                                          |  52%  121 MB
|================================================                                          |  53%  121 MB
|================================================                                          |  53%  121 MB
|================================================                                          |  53%  121 MB
|================================================                                          |  53%  121 MB
|================================================                                          |  53%  121 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  123 MB
|================================================                                          |  53%  123 MB
|================================================                                          |  53%  123 MB
|=================================================                                         |  53%  123 MB
|=================================================                                         |  53%  123 MB
|=================================================                                         |  54%  123 MB
|=================================================                                         |  54%  123 MB
|=================================================                                         |  54%  123 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  125 MB
|=================================================                                         |  54%  125 MB
|=================================================                                         |  54%  125 MB
|=================================================                                         |  54%  125 MB
|=================================================                                         |  54%  125 MB
|=================================================                                         |  54%  125 MB
|=================================================                                         |  54%  125 MB
|==================================================                                        |  54%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  128 MB
|==================================================                                        |  55%  128 MB
|==================================================                                        |  55%  128 MB
|==================================================                                        |  56%  128 MB
|===================================================                                       |  56%  128 MB
|===================================================                                       |  56%  128 MB
|===================================================                                       |  56%  128 MB
|===================================================                                       |  56%  128 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  130 MB
|===================================================                                       |  56%  130 MB
|===================================================                                       |  56%  130 MB
|===================================================                                       |  56%  130 MB
|===================================================                                       |  56%  130 MB
|===================================================                                       |  57%  130 MB
|===================================================                                       |  57%  130 MB
|===================================================                                       |  57%  130 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  58%  132 MB
|====================================================                                      |  58%  133 MB
|====================================================                                      |  58%  133 MB
|====================================================                                      |  58%  133 MB
|====================================================                                      |  58%  133 MB
|=====================================================                                     |  58%  133 MB
|=====================================================                                     |  58%  133 MB
|=====================================================                                     |  58%  133 MB
|=====================================================                                     |  58%  133 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  135 MB
|=====================================================                                     |  58%  135 MB
|=====================================================                                     |  59%  135 MB
|=====================================================                                     |  59%  135 MB
|=====================================================                                     |  59%  135 MB
|=====================================================                                     |  59%  135 MB
|=====================================================                                     |  59%  135 MB
|=====================================================                                     |  59%  135 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  137 MB
|======================================================                                    |  59%  137 MB
|======================================================                                    |  59%  137 MB
|======================================================                                    |  59%  137 MB
|======================================================                                    |  60%  137 MB
|======================================================                                    |  60%  137 MB
|======================================================                                    |  60%  137 MB
|======================================================                                    |  60%  137 MB
|======================================================                                    |  60%  138 MB
|======================================================                                    |  60%  138 MB
|======================================================                                    |  60%  138 MB
|======================================================                                    |  60%  138 MB
|=======================================================                                   |  60%  138 MB
|=======================================================                                   |  60%  138 MB
|=======================================================                                   |  60%  138 MB
|=======================================================                                   |  60%  138 MB
|=======================================================                                   |  60%  139 MB
|=======================================================                                   |  60%  139 MB
|=======================================================                                   |  60%  139 MB
|=======================================================                                   |  60%  139 MB
|=======================================================                                   |  60%  139 MB
|=======================================================                                   |  60%  139 MB
|=======================================================                                   |  61%  139 MB
|=======================================================                                   |  61%  139 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  143 MB
|========================================================                                  |  62%  143 MB
|========================================================                                  |  62%  143 MB
|========================================================                                  |  62%  143 MB
|=========================================================                                 |  62%  143 MB
|=========================================================                                 |  62%  143 MB
|=========================================================                                 |  62%  143 MB
|=========================================================                                 |  62%  143 MB
|=========================================================                                 |  62%  144 MB
|=========================================================                                 |  62%  144 MB
|=========================================================                                 |  63%  144 MB
|=========================================================                                 |  63%  144 MB
|=========================================================                                 |  63%  144 MB
|=========================================================                                 |  63%  144 MB
|=========================================================                                 |  63%  144 MB
|=========================================================                                 |  63%  144 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|==========================================================                                |  63%  146 MB
|==========================================================                                |  63%  146 MB
|==========================================================                                |  63%  146 MB
|==========================================================                                |  63%  146 MB
|==========================================================                                |  63%  146 MB
|==========================================================                                |  64%  146 MB
|==========================================================                                |  64%  146 MB
|==========================================================                                |  64%  146 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  148 MB
|==========================================================                                |  64%  148 MB
|==========================================================                                |  64%  148 MB
|==========================================================                                |  64%  148 MB
|===========================================================                               |  64%  148 MB
|===========================================================                               |  64%  148 MB
|===========================================================                               |  64%  148 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  151 MB
|============================================================                              |  65%  151 MB
|============================================================                              |  66%  151 MB
|============================================================                              |  66%  151 MB
|============================================================                              |  66%  151 MB
|============================================================                              |  66%  151 MB
|============================================================                              |  66%  151 MB
|============================================================                              |  66%  151 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  153 MB
|============================================================                              |  66%  153 MB
|============================================================                              |  66%  153 MB
|============================================================                              |  66%  153 MB
|============================================================                              |  67%  153 MB
|=============================================================                             |  67%  153 MB
|=============================================================                             |  67%  153 MB
|=============================================================                             |  67%  153 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  155 MB
|=============================================================                             |  67%  155 MB
|=============================================================                             |  67%  155 MB
|=============================================================                             |  67%  155 MB
|=============================================================                             |  67%  155 MB
|=============================================================                             |  67%  155 MB
|=============================================================                             |  68%  155 MB
|=============================================================                             |  68%  155 MB
|=============================================================                             |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  158 MB
|==============================================================                            |  69%  158 MB
|==============================================================                            |  69%  158 MB
|==============================================================                            |  69%  158 MB
|==============================================================                            |  69%  158 MB
|===============================================================                           |  69%  158 MB
|===============================================================                           |  69%  158 MB
|===============================================================                           |  69%  158 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  160 MB
|===============================================================                           |  69%  160 MB
|===============================================================                           |  69%  160 MB
|===============================================================                           |  70%  160 MB
|===============================================================                           |  70%  160 MB
|===============================================================                           |  70%  160 MB
|===============================================================                           |  70%  160 MB
|===============================================================                           |  70%  160 MB
|===============================================================                           |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  162 MB
|================================================================                          |  70%  162 MB
|================================================================                          |  70%  162 MB
|================================================================                          |  70%  162 MB
|================================================================                          |  70%  162 MB
|================================================================                          |  71%  162 MB
|================================================================                          |  71%  162 MB
|================================================================                          |  71%  162 MB
|================================================================                          |  71%  163 MB
|================================================================                          |  71%  163 MB
|================================================================                          |  71%  163 MB
|================================================================                          |  71%  163 MB
|================================================================                          |  71%  163 MB
|=================================================================                         |  71%  163 MB
|=================================================================                         |  71%  163 MB
|=================================================================                         |  71%  163 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  72%  164 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  167 MB
|==================================================================                        |  72%  167 MB
|==================================================================                        |  73%  167 MB
|==================================================================                        |  73%  167 MB
|==================================================================                        |  73%  167 MB
|==================================================================                        |  73%  167 MB
|==================================================================                        |  73%  167 MB
|==================================================================                        |  73%  167 MB
|==================================================================                        |  73%  168 MB
|==================================================================                        |  73%  168 MB
|==================================================================                        |  73%  168 MB
|==================================================================                        |  73%  168 MB
|==================================================================                        |  73%  168 MB
|===================================================================                       |  73%  168 MB
|===================================================================                       |  73%  168 MB
|===================================================================                       |  73%  168 MB
|===================================================================                       |  73%  169 MB
|===================================================================                       |  73%  169 MB
|===================================================================                       |  73%  169 MB
|===================================================================                       |  73%  169 MB
|===================================================================                       |  74%  169 MB
|===================================================================                       |  74%  169 MB
|===================================================================                       |  74%  169 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  171 MB
|===================================================================                       |  74%  171 MB
|====================================================================                      |  74%  171 MB
|====================================================================                      |  74%  171 MB
|====================================================================                      |  74%  171 MB
|====================================================================                      |  74%  171 MB
|====================================================================                      |  74%  171 MB
|====================================================================                      |  75%  171 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  173 MB
|====================================================================                      |  75%  173 MB
|====================================================================                      |  75%  173 MB
|====================================================================                      |  75%  173 MB
|====================================================================                      |  75%  173 MB
|====================================================================                      |  75%  173 MB
|=====================================================================                     |  75%  173 MB
|=====================================================================                     |  75%  173 MB
|=====================================================================                     |  75%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  176 MB
|=====================================================================                     |  76%  176 MB
|======================================================================                    |  76%  176 MB
|======================================================================                    |  76%  176 MB
|======================================================================                    |  77%  176 MB
|======================================================================                    |  77%  176 MB
|======================================================================                    |  77%  176 MB
|======================================================================                    |  77%  176 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  178 MB
|======================================================================                    |  77%  178 MB
|======================================================================                    |  77%  178 MB
|======================================================================                    |  77%  178 MB
|======================================================================                    |  77%  178 MB
|======================================================================                    |  77%  178 MB
|=======================================================================                   |  78%  178 MB
|=======================================================================                   |  78%  178 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  79%  181 MB
|=======================================================================                   |  79%  181 MB
|========================================================================                  |  79%  181 MB
|========================================================================                  |  79%  181 MB
|========================================================================                  |  79%  181 MB
|========================================================================                  |  79%  181 MB
|========================================================================                  |  79%  181 MB
|========================================================================                  |  79%  181 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  183 MB
|========================================================================                  |  79%  183 MB
|========================================================================                  |  80%  183 MB
|========================================================================                  |  80%  183 MB
|========================================================================                  |  80%  183 MB
|========================================================================                  |  80%  183 MB
|=========================================================================                 |  80%  183 MB
|=========================================================================                 |  80%  183 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  185 MB
|=========================================================================                 |  80%  185 MB
|=========================================================================                 |  80%  185 MB
|=========================================================================                 |  80%  185 MB
|=========================================================================                 |  81%  185 MB
|=========================================================================                 |  81%  185 MB
|=========================================================================                 |  81%  185 MB
|=========================================================================                 |  81%  185 MB
|=========================================================================                 |  81%  186 MB
|=========================================================================                 |  81%  186 MB
|==========================================================================                |  81%  186 MB
|==========================================================================                |  81%  186 MB
|==========================================================================                |  81%  186 MB
|==========================================================================                |  81%  186 MB
|==========================================================================                |  81%  186 MB
|==========================================================================                |  81%  186 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  82%  187 MB
|==========================================================================                |  82%  188 MB
|==========================================================================                |  82%  188 MB
|==========================================================================                |  82%  188 MB
|==========================================================================                |  82%  188 MB
|==========================================================================                |  82%  188 MB
|==========================================================================                |  82%  188 MB
|===========================================================================               |  82%  188 MB
|===========================================================================               |  82%  188 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  190 MB
|===========================================================================               |  82%  190 MB
|===========================================================================               |  83%  190 MB
|===========================================================================               |  83%  190 MB
|===========================================================================               |  83%  190 MB
|===========================================================================               |  83%  190 MB
|===========================================================================               |  83%  190 MB
|===========================================================================               |  83%  190 MB
|===========================================================================               |  83%  191 MB
|===========================================================================               |  83%  191 MB
|===========================================================================               |  83%  191 MB
|============================================================================              |  83%  191 MB
|============================================================================              |  83%  191 MB
|============================================================================              |  83%  191 MB
|============================================================================              |  83%  191 MB
|============================================================================              |  83%  191 MB
|============================================================================              |  83%  192 MB
|============================================================================              |  83%  192 MB
|============================================================================              |  83%  192 MB
|============================================================================              |  83%  192 MB
|============================================================================              |  84%  192 MB
|============================================================================              |  84%  192 MB
|============================================================================              |  84%  192 MB
|============================================================================              |  84%  192 MB
|============================================================================              |  84%  193 MB
|============================================================================              |  84%  193 MB
|============================================================================              |  84%  193 MB
|============================================================================              |  84%  193 MB
|============================================================================              |  84%  193 MB
|============================================================================              |  84%  193 MB
|============================================================================              |  84%  193 MB
|=============================================================================             |  84%  193 MB
|=============================================================================             |  84%  194 MB
|=============================================================================             |  84%  194 MB
|=============================================================================             |  84%  194 MB
|=============================================================================             |  84%  194 MB
|=============================================================================             |  84%  194 MB
|=============================================================================             |  84%  194 MB
|=============================================================================             |  85%  194 MB
|=============================================================================             |  85%  194 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  196 MB
|=============================================================================             |  85%  196 MB
|=============================================================================             |  85%  196 MB
|==============================================================================            |  85%  196 MB
|==============================================================================            |  85%  196 MB
|==============================================================================            |  85%  196 MB
|==============================================================================            |  85%  196 MB
|==============================================================================            |  85%  196 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  198 MB
|==============================================================================            |  86%  198 MB
|==============================================================================            |  86%  198 MB
|==============================================================================            |  86%  198 MB
|==============================================================================            |  86%  198 MB
|==============================================================================            |  86%  198 MB
|==============================================================================            |  86%  198 MB
|===============================================================================           |  86%  199 MB
|===============================================================================           |  86%  199 MB
|===============================================================================           |  86%  199 MB
|===============================================================================           |  87%  199 MB
|===============================================================================           |  87%  199 MB
|===============================================================================           |  87%  199 MB
|===============================================================================           |  87%  199 MB
|===============================================================================           |  87%  199 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  201 MB
|===============================================================================           |  87%  201 MB
|===============================================================================           |  87%  201 MB
|================================================================================          |  87%  201 MB
|================================================================================          |  87%  201 MB
|================================================================================          |  88%  201 MB
|================================================================================          |  88%  201 MB
|================================================================================          |  88%  201 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  203 MB
|================================================================================          |  88%  203 MB
|================================================================================          |  88%  203 MB
|================================================================================          |  88%  203 MB
|================================================================================          |  88%  203 MB
|================================================================================          |  88%  203 MB
|================================================================================          |  88%  203 MB
|=================================================================================         |  89%  203 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  206 MB
|=================================================================================         |  90%  206 MB
|=================================================================================         |  90%  206 MB
|==================================================================================        |  90%  206 MB
|==================================================================================        |  90%  206 MB
|==================================================================================        |  90%  206 MB
|==================================================================================        |  90%  206 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  208 MB
|==================================================================================        |  90%  208 MB
|==================================================================================        |  90%  208 MB
|==================================================================================        |  90%  208 MB
|==================================================================================        |  91%  208 MB
|==================================================================================        |  91%  208 MB
|==================================================================================        |  91%  208 MB
|==================================================================================        |  91%  208 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  210 MB
|===================================================================================       |  91%  210 MB
|===================================================================================       |  91%  210 MB
|===================================================================================       |  91%  210 MB
|===================================================================================       |  91%  210 MB
|===================================================================================       |  91%  210 MB
|===================================================================================       |  92%  210 MB
|===================================================================================       |  92%  210 MB
|===================================================================================       |  92%  211 MB
|===================================================================================       |  92%  211 MB
|===================================================================================       |  92%  211 MB
|===================================================================================       |  92%  211 MB
|====================================================================================      |  92%  211 MB
|====================================================================================      |  92%  211 MB
|====================================================================================      |  92%  211 MB
|====================================================================================      |  92%  211 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  215 MB
|=====================================================================================     |  93%  215 MB
|=====================================================================================     |  93%  215 MB
|=====================================================================================     |  94%  215 MB
|=====================================================================================     |  94%  215 MB
|=====================================================================================     |  94%  215 MB
|=====================================================================================     |  94%  215 MB
|=====================================================================================     |  94%  215 MB
|=====================================================================================     |  94%  216 MB
|=====================================================================================     |  94%  216 MB
|=====================================================================================     |  94%  216 MB
|=====================================================================================     |  94%  216 MB
|======================================================================================    |  94%  216 MB
|======================================================================================    |  94%  216 MB
|======================================================================================    |  94%  216 MB
|======================================================================================    |  94%  217 MB
|======================================================================================    |  94%  217 MB
|======================================================================================    |  94%  217 MB
|======================================================================================    |  94%  217 MB
|======================================================================================    |  94%  217 MB
|======================================================================================    |  94%  217 MB
|======================================================================================    |  95%  217 MB
|======================================================================================    |  95%  217 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  221 MB
|=======================================================================================   |  96%  221 MB
|=======================================================================================   |  96%  221 MB
|=======================================================================================   |  96%  221 MB
|========================================================================================  |  96%  221 MB
|========================================================================================  |  96%  221 MB
|========================================================================================  |  96%  221 MB
|========================================================================================  |  96%  221 MB
|========================================================================================  |  96%  222 MB
|========================================================================================  |  96%  222 MB
|========================================================================================  |  97%  222 MB
|========================================================================================  |  97%  222 MB
|========================================================================================  |  97%  222 MB
|========================================================================================  |  97%  222 MB
|========================================================================================  |  97%  222 MB
|========================================================================================  |  97%  222 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================= |  97%  224 MB
|========================================================================================= |  97%  224 MB
|========================================================================================= |  97%  224 MB
|========================================================================================= |  97%  224 MB
|========================================================================================= |  98%  224 MB
|========================================================================================= |  98%  224 MB
|========================================================================================= |  98%  224 MB
|========================================================================================= |  98%  224 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  226 MB
|========================================================================================= |  98%  226 MB
|========================================================================================= |  98%  226 MB
|========================================================================================= |  98%  226 MB
|========================================================================================= |  98%  226 MB
|==========================================================================================|  98%  226 MB
|==========================================================================================|  98%  226 MB
|==========================================================================================|  99%  226 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  229 MB
|===========================================================================================| 100%  229 MB
crime_12062016_to_03192018 <- 
  read_csv("./data/DPD__All_Crime_Incidents__December_6__2016_-_3_19_2018.csv", 
           guess_max = 10^6)
Parsed with column specification:
cols(
  .default = col_character(),
  `Crime ID` = col_integer(),
  `Day of Week (Sunday is 1)` = col_integer(),
  `Hour of Day` = col_integer(),
  Year = col_integer(),
  `Census Block GEOID` = col_double(),
  `Council District` = col_integer(),
  `Zip Code` = col_integer(),
  Longitude = col_double(),
  Latitude = col_double(),
  uniq = col_integer()
)
See spec(...) for full column specifications.

|=                                                                                                 |   1%
|=                                                                                                 |   1%
|==                                                                                                |   2%
|==                                                                                                |   2%
|==                                                                                                |   2%
|===                                                                                       |   3%    1 MB
|===                                                                                       |   3%    1 MB
|===                                                                                       |   4%    1 MB
|====                                                                                      |   4%    1 MB
|====                                                                                      |   5%    1 MB
|====                                                                                      |   5%    1 MB
|=====                                                                                     |   5%    1 MB
|=====                                                                                     |   6%    1 MB
|======                                                                                    |   6%    2 MB
|======                                                                                    |   7%    2 MB
|======                                                                                    |   7%    2 MB
|=======                                                                                   |   7%    2 MB
|=======                                                                                   |   8%    2 MB
|=======                                                                                   |   8%    2 MB
|========                                                                                  |   9%    2 MB
|========                                                                                  |   9%    2 MB
|========                                                                                  |   9%    3 MB
|=========                                                                                 |  10%    3 MB
|=========                                                                                 |  10%    3 MB
|==========                                                                                |  11%    3 MB
|==========                                                                                |  11%    3 MB
|==========                                                                                |  11%    3 MB
|===========                                                                               |  12%    3 MB
|===========                                                                               |  12%    3 MB
|===========                                                                               |  13%    4 MB
|============                                                                              |  13%    4 MB
|============                                                                              |  13%    4 MB
|=============                                                                             |  14%    4 MB
|=============                                                                             |  14%    4 MB
|=============                                                                             |  15%    4 MB
|==============                                                                            |  15%    4 MB
|==============                                                                            |  15%    4 MB
|==============                                                                            |  16%    5 MB
|===============                                                                           |  16%    5 MB
|===============                                                                           |  17%    5 MB
|===============                                                                           |  17%    5 MB
|================                                                                          |  17%    5 MB
|================                                                                          |  18%    5 MB
|=================                                                                         |  18%    5 MB
|=================                                                                         |  19%    5 MB
|=================                                                                         |  19%    6 MB
|==================                                                                        |  19%    6 MB
|==================                                                                        |  20%    6 MB
|==================                                                                        |  20%    6 MB
|===================                                                                       |  21%    6 MB
|===================                                                                       |  21%    6 MB
|====================                                                                      |  22%    6 MB
|====================                                                                      |  22%    6 MB
|====================                                                                      |  22%    7 MB
|=====================                                                                     |  23%    7 MB
|=====================                                                                     |  23%    7 MB
|=====================                                                                     |  24%    7 MB
|======================                                                                    |  24%    7 MB
|======================                                                                    |  24%    7 MB
|======================                                                                    |  25%    7 MB
|=======================                                                                   |  25%    7 MB
|=======================                                                                   |  26%    8 MB
|========================                                                                  |  26%    8 MB
|========================                                                                  |  26%    8 MB
|========================                                                                  |  27%    8 MB
|=========================                                                                 |  27%    8 MB
|=========================                                                                 |  28%    8 MB
|=========================                                                                 |  28%    8 MB
|==========================                                                                |  28%    8 MB
|==========================                                                                |  29%    9 MB
|===========================                                                               |  29%    9 MB
|===========================                                                               |  30%    9 MB
|===========================                                                               |  30%    9 MB
|============================                                                              |  30%    9 MB
|============================                                                              |  31%    9 MB
|============================                                                              |  31%    9 MB
|=============================                                                             |  32%    9 MB
|=============================                                                             |  32%   10 MB
|==============================                                                            |  32%   10 MB
|==============================                                                            |  33%   10 MB
|==============================                                                            |  33%   10 MB
|===============================                                                           |  34%   10 MB
|===============================                                                           |  34%   10 MB
|===============================                                                           |  35%   10 MB
|================================                                                          |  35%   10 MB
|================================                                                          |  35%   11 MB
|================================                                                          |  36%   11 MB
|=================================                                                         |  36%   11 MB
|=================================                                                         |  37%   11 MB
|==================================                                                        |  37%   11 MB
|==================================                                                        |  37%   11 MB
|==================================                                                        |  38%   11 MB
|===================================                                                       |  38%   11 MB
|===================================                                                       |  39%   12 MB
|===================================                                                       |  39%   12 MB
|====================================                                                      |  39%   12 MB
|====================================                                                      |  40%   12 MB
|=====================================                                                     |  40%   12 MB
|=====================================                                                     |  41%   12 MB
|=====================================                                                     |  41%   12 MB
|======================================                                                    |  41%   12 MB
|======================================                                                    |  42%   13 MB
|======================================                                                    |  42%   13 MB
|=======================================                                                   |  43%   13 MB
|=======================================                                                   |  43%   13 MB
|========================================                                                  |  43%   13 MB
|========================================                                                  |  44%   13 MB
|========================================                                                  |  44%   13 MB
|=========================================                                                 |  45%   13 MB
|=========================================                                                 |  45%   14 MB
|=========================================                                                 |  45%   14 MB
|==========================================                                                |  46%   14 MB
|==========================================                                                |  46%   14 MB
|==========================================                                                |  47%   14 MB
|===========================================                                               |  47%   14 MB
|===========================================                                               |  48%   14 MB
|============================================                                              |  48%   14 MB
|============================================                                              |  48%   15 MB
|============================================                                              |  49%   15 MB
|=============================================                                             |  49%   15 MB
|=============================================                                             |  50%   15 MB
|=============================================                                             |  50%   15 MB
|==============================================                                            |  50%   15 MB
|==============================================                                            |  51%   15 MB
|===============================================                                           |  51%   15 MB
|===============================================                                           |  52%   16 MB
|===============================================                                           |  52%   16 MB
|================================================                                          |  52%   16 MB
|================================================                                          |  53%   16 MB
|================================================                                          |  53%   16 MB
|=================================================                                         |  54%   16 MB
|=================================================                                         |  54%   16 MB
|=================================================                                         |  54%   16 MB
|==================================================                                        |  55%   17 MB
|==================================================                                        |  55%   17 MB
|===================================================                                       |  56%   17 MB
|===================================================                                       |  56%   17 MB
|===================================================                                       |  56%   17 MB
|====================================================                                      |  57%   17 MB
|====================================================                                      |  57%   17 MB
|====================================================                                      |  58%   18 MB
|=====================================================                                     |  58%   18 MB
|=====================================================                                     |  59%   18 MB
|======================================================                                    |  59%   18 MB
|======================================================                                    |  59%   18 MB
|======================================================                                    |  60%   18 MB
|=======================================================                                   |  60%   18 MB
|=======================================================                                   |  61%   18 MB
|=======================================================                                   |  61%   19 MB
|========================================================                                  |  61%   19 MB
|========================================================                                  |  62%   19 MB
|=========================================================                                 |  62%   19 MB
|=========================================================                                 |  63%   19 MB
|=========================================================                                 |  63%   19 MB
|==========================================================                                |  63%   19 MB
|==========================================================                                |  64%   19 MB
|==========================================================                                |  64%   20 MB
|===========================================================                               |  65%   20 MB
|===========================================================                               |  65%   20 MB
|============================================================                              |  65%   20 MB
|============================================================                              |  66%   20 MB
|============================================================                              |  66%   20 MB
|=============================================================                             |  67%   20 MB
|=============================================================                             |  67%   20 MB
|=============================================================                             |  67%   21 MB
|==============================================================                            |  68%   21 MB
|==============================================================                            |  68%   21 MB
|==============================================================                            |  69%   21 MB
|===============================================================                           |  69%   21 MB
|===============================================================                           |  70%   21 MB
|================================================================                          |  70%   21 MB
|================================================================                          |  70%   21 MB
|================================================================                          |  71%   22 MB
|=================================================================                         |  71%   22 MB
|=================================================================                         |  72%   22 MB
|=================================================================                         |  72%   22 MB
|==================================================================                        |  72%   22 MB
|==================================================================                        |  73%   22 MB
|===================================================================                       |  73%   22 MB
|===================================================================                       |  74%   22 MB
|===================================================================                       |  74%   23 MB
|====================================================================                      |  74%   23 MB
|====================================================================                      |  75%   23 MB
|====================================================================                      |  75%   23 MB
|=====================================================================                     |  76%   23 MB
|=====================================================================                     |  76%   23 MB
|=====================================================================                     |  76%   23 MB
|======================================================================                    |  77%   23 MB
|======================================================================                    |  77%   24 MB
|=======================================================================                   |  78%   24 MB
|=======================================================================                   |  78%   24 MB
|=======================================================================                   |  78%   24 MB
|========================================================================                  |  79%   24 MB
|========================================================================                  |  79%   24 MB
|========================================================================                  |  80%   24 MB
|=========================================================================                 |  80%   24 MB
|=========================================================================                 |  80%   25 MB
|==========================================================================                |  81%   25 MB
|==========================================================================                |  81%   25 MB
|==========================================================================                |  82%   25 MB
|===========================================================================               |  82%   25 MB
|===========================================================================               |  83%   25 MB
|===========================================================================               |  83%   25 MB
|============================================================================              |  83%   25 MB
|============================================================================              |  84%   26 MB
|=============================================================================             |  84%   26 MB
|=============================================================================             |  85%   26 MB
|=============================================================================             |  85%   26 MB
|==============================================================================            |  85%   26 MB
|==============================================================================            |  86%   26 MB
|==============================================================================            |  86%   26 MB
|===============================================================================           |  87%   26 MB
|===============================================================================           |  87%   27 MB
|===============================================================================           |  87%   27 MB
|================================================================================          |  88%   27 MB
|================================================================================          |  88%   27 MB
|=================================================================================         |  89%   27 MB
|=================================================================================         |  89%   27 MB
|=================================================================================         |  89%   27 MB
|==================================================================================        |  90%   27 MB
|==================================================================================        |  90%   28 MB
|==================================================================================        |  91%   28 MB
|===================================================================================       |  91%   28 MB
|===================================================================================       |  91%   28 MB
|====================================================================================      |  92%   28 MB
|====================================================================================      |  92%   28 MB
|====================================================================================      |  93%   28 MB
|=====================================================================================     |  93%   28 MB
|=====================================================================================     |  94%   29 MB
|=====================================================================================     |  94%   29 MB
|======================================================================================    |  94%   29 MB
|======================================================================================    |  95%   29 MB
|=======================================================================================   |  95%   29 MB
|=======================================================================================   |  96%   29 MB
|=======================================================================================   |  96%   29 MB
|========================================================================================  |  96%   29 MB
|========================================================================================  |  97%   30 MB
|========================================================================================  |  97%   30 MB
|========================================================================================= |  98%   30 MB
|========================================================================================= |  98%   30 MB
|==========================================================================================|  98%   30 MB
|==========================================================================================|  99%   30 MB
|==========================================================================================|  99%   30 MB
|===========================================================================================| 100%   30 MB
#the 311 system
improve_detroit_issues <- read_csv("./data/Improve_Detroit_Issues_3_19_2018.csv", 
                                   guess_max = 10^6)
Parsed with column specification:
cols(
  `Ticket ID` = col_integer(),
  `Ticket Status` = col_character(),
  `Issue Type` = col_character(),
  `Issue Description` = col_character(),
  `Created At` = col_character(),
  `Acknowledged At` = col_character(),
  `Closed At` = col_character(),
  `Reopened At` = col_character(),
  `Updated At` = col_character(),
  `Days to Close` = col_double(),
  `Report Method` = col_character(),
  `Priority Code` = col_integer(),
  `Canonical Issue Id` = col_integer(),
  `Web Link` = col_character(),
  Address = col_character(),
  Neighborhood = col_character(),
  `Council District` = col_integer(),
  Location = col_character()
)

|==========                                                                                |  11%    4 MB
|===========                                                                               |  12%    4 MB
|===========                                                                               |  12%    4 MB
|============                                                                              |  13%    5 MB
|============                                                                              |  13%    5 MB
|============                                                                              |  14%    5 MB
|=============                                                                             |  14%    5 MB
|=============                                                                             |  15%    5 MB
|==============                                                                            |  15%    5 MB
|==============                                                                            |  16%    6 MB
|===============                                                                           |  16%    6 MB
|===============                                                                           |  17%    6 MB
|===============                                                                           |  17%    6 MB
|================                                                                          |  17%    6 MB
|================                                                                          |  18%    7 MB
|=================                                                                         |  18%    7 MB
|=================                                                                         |  19%    7 MB
|==================                                                                        |  19%    7 MB
|==================                                                                        |  20%    7 MB
|==================                                                                        |  20%    7 MB
|===================                                                                       |  21%    8 MB
|===================                                                                       |  21%    8 MB
|====================                                                                      |  22%    8 MB
|====================                                                                      |  22%    8 MB
|=====================                                                                     |  23%    8 MB
|=====================                                                                     |  23%    8 MB
|=====================                                                                     |  24%    9 MB
|======================                                                                    |  24%    9 MB
|======================                                                                    |  25%    9 MB
|=======================                                                                   |  25%    9 MB
|=======================                                                                   |  25%    9 MB
|========================                                                                  |  26%   10 MB
|========================                                                                  |  26%   10 MB
|========================                                                                  |  27%   10 MB
|=========================                                                                 |  27%   10 MB
|=========================                                                                 |  28%   10 MB
|==========================                                                                |  28%   10 MB
|==========================                                                                |  29%   11 MB
|===========================                                                               |  29%   11 MB
|===========================                                                               |  30%   11 MB
|===========================                                                               |  30%   11 MB
|============================                                                              |  31%   11 MB
|============================                                                              |  31%   12 MB
|=============================                                                             |  32%   12 MB
|=============================                                                             |  32%   12 MB
|==============================                                                            |  33%   12 MB
|==============================                                                            |  33%   12 MB
|==============================                                                            |  33%   12 MB
|===============================                                                           |  34%   13 MB
|===============================                                                           |  34%   13 MB
|================================                                                          |  35%   13 MB
|================================                                                          |  35%   13 MB
|=================================                                                         |  36%   13 MB
|=================================                                                         |  36%   14 MB
|=================================                                                         |  37%   14 MB
|==================================                                                        |  37%   14 MB
|==================================                                                        |  38%   14 MB
|===================================                                                       |  38%   14 MB
|===================================                                                       |  39%   14 MB
|====================================                                                      |  39%   15 MB
|====================================                                                      |  40%   15 MB
|====================================                                                      |  40%   15 MB
|=====================================                                                     |  41%   15 MB
|=====================================                                                     |  41%   15 MB
|======================================                                                    |  41%   15 MB
|======================================                                                    |  42%   16 MB
|=======================================                                                   |  42%   16 MB
|=======================================                                                   |  43%   16 MB
|=======================================                                                   |  43%   16 MB
|========================================                                                  |  44%   16 MB
|========================================                                                  |  44%   17 MB
|=========================================                                                 |  45%   17 MB
|=========================================                                                 |  45%   17 MB
|=========================================                                                 |  46%   17 MB
|==========================================                                                |  46%   17 MB
|==========================================                                                |  47%   17 MB
|===========================================                                               |  47%   18 MB
|===========================================                                               |  48%   18 MB
|============================================                                              |  48%   18 MB
|============================================                                              |  49%   18 MB
|=============================================                                             |  49%   18 MB
|=============================================                                             |  49%   19 MB
|=============================================                                             |  50%   19 MB
|==============================================                                            |  50%   19 MB
|==============================================                                            |  51%   19 MB
|===============================================                                           |  51%   19 MB
|===============================================                                           |  52%   19 MB
|================================================                                          |  52%   20 MB
|================================================                                          |  53%   20 MB
|================================================                                          |  53%   20 MB
|=================================================                                         |  54%   20 MB
|=================================================                                         |  54%   20 MB
|==================================================                                        |  55%   21 MB
|==================================================                                        |  55%   21 MB
|===================================================                                       |  56%   21 MB
|===================================================                                       |  56%   21 MB
|===================================================                                       |  57%   21 MB
|====================================================                                      |  57%   21 MB
|====================================================                                      |  58%   22 MB
|=====================================================                                     |  58%   22 MB
|=====================================================                                     |  59%   22 MB
|======================================================                                    |  59%   22 MB
|======================================================                                    |  59%   22 MB
|======================================================                                    |  60%   22 MB
|=======================================================                                   |  60%   23 MB
|=======================================================                                   |  61%   23 MB
|========================================================                                  |  61%   23 MB
|========================================================                                  |  62%   23 MB
|=========================================================                                 |  62%   23 MB
|=========================================================                                 |  63%   24 MB
|==========================================================                                |  63%   24 MB
|==========================================================                                |  64%   24 MB
|==========================================================                                |  64%   24 MB
|===========================================================                               |  65%   24 MB
|===========================================================                               |  65%   24 MB
|============================================================                              |  66%   25 MB
|============================================================                              |  66%   25 MB
|=============================================================                             |  67%   25 MB
|=============================================================                             |  67%   25 MB
|=============================================================                             |  68%   25 MB
|==============================================================                            |  68%   26 MB
|==============================================================                            |  69%   26 MB
|===============================================================                           |  69%   26 MB
|===============================================================                           |  69%   26 MB
|================================================================                          |  70%   26 MB
|================================================================                          |  70%   27 MB
|=================================================================                         |  71%   27 MB
|=================================================================                         |  71%   27 MB
|=================================================================                         |  72%   27 MB
|==================================================================                        |  72%   27 MB
|==================================================================                        |  73%   27 MB
|===================================================================                       |  73%   28 MB
|===================================================================                       |  74%   28 MB
|===================================================================                       |  74%   28 MB
|====================================================================                      |  75%   28 MB
|====================================================================                      |  75%   28 MB
|=====================================================================                     |  76%   28 MB
|=====================================================================                     |  76%   29 MB
|======================================================================                    |  76%   29 MB
|======================================================================                    |  77%   29 MB
|======================================================================                    |  77%   29 MB
|=======================================================================                   |  78%   29 MB
|=======================================================================                   |  78%   29 MB
|========================================================================                  |  79%   30 MB
|========================================================================                  |  79%   30 MB
|========================================================================                  |  80%   30 MB
|=========================================================================                 |  80%   30 MB
|=========================================================================                 |  81%   30 MB
|==========================================================================                |  81%   31 MB
|==========================================================================                |  81%   31 MB
|==========================================================================                |  82%   31 MB
|===========================================================================               |  82%   31 MB
|===========================================================================               |  83%   31 MB
|============================================================================              |  83%   31 MB
|============================================================================              |  84%   32 MB
|=============================================================================             |  84%   32 MB
|=============================================================================             |  85%   32 MB
|=============================================================================             |  85%   32 MB
|==============================================================================            |  86%   32 MB
|==============================================================================            |  86%   32 MB
|===============================================================================           |  86%   33 MB
|===============================================================================           |  87%   33 MB
|===============================================================================           |  87%   33 MB
|================================================================================          |  88%   33 MB
|================================================================================          |  88%   33 MB
|=================================================================================         |  89%   33 MB
|=================================================================================         |  89%   34 MB
|==================================================================================        |  90%   34 MB
|==================================================================================        |  90%   34 MB
|==================================================================================        |  91%   34 MB
|===================================================================================       |  91%   34 MB
|===================================================================================       |  92%   35 MB
|====================================================================================      |  92%   35 MB
|====================================================================================      |  93%   35 MB
|=====================================================================================     |  93%   35 MB
|=====================================================================================     |  93%   35 MB
|=====================================================================================     |  94%   35 MB
|======================================================================================    |  94%   36 MB
|======================================================================================    |  95%   36 MB
|=======================================================================================   |  95%   36 MB
|=======================================================================================   |  96%   36 MB
|========================================================================================  |  96%   36 MB
|========================================================================================  |  97%   37 MB
|========================================================================================  |  97%   37 MB
|========================================================================================= |  98%   37 MB
|========================================================================================= |  98%   37 MB
|==========================================================================================|  99%   37 MB
|==========================================================================================|  99%   37 MB
|===========================================================================================| 100%   38 MB
#the shapefile representing Detroit parcels, read into 
parcel_sf <- st_read("./data/Parcel Map")
Reading layer `geo_export_ad366f11-96e5-4f0f-9d17-7a6ae8e48482' from data source `/Users/stuartbarnum/Desktop/R files/Detroit-Demolitions/data/Parcel Map' using driver `ESRI Shapefile'
Simple feature collection with 382051 features and 37 fields
geometry type:  MULTIPOLYGON
dimension:      XY
bbox:           xmin: -83.28763 ymin: 42.25539 xmax: -82.91066 ymax: 42.45011
epsg (SRID):    4326
proj4string:    +proj=longlat +ellps=WGS84 +no_defs
#writeLines(c("parcel_sf", " ", colnames(parcel_sf)), "parcel_sf.txt")

For all of the downloaded datasets other than the parcels dataset, we extract extract the usable latutude and longitude values and then use this information to form simple features (sf) objects. Rows with obviously incorrect values, or values that would represent positions well outside Detroit, are filtered out, together with rows for which the latitude or longitude data is missing.

#function for converting the position (character) column into a column of points in the simple features (sf) framework.
add_sf_point <- function(df, column) {
  
  #extract the latitude and longitude from the string column that contains both. With the parentheses
  #located from the end of the strings, it is possible to use the the same function for all five of 
  #the datasets for which we need to extract this information.
  latitude <- str_sub(df[[column]], 
                      stringi::stri_locate_last_fixed(df[[column]], "(")[,2] + 1,
                      stringi::stri_locate_last_fixed(df[[column]], ",")[,1] - 1)
  longitude <- str_sub(df[[column]], 
                       stringi::stri_locate_last_fixed(df[[column]], ", ")[,2] + 1, 
                       stringi::stri_locate_last_fixed(df[[column]], ")")[,1] - 1)
  
  #add the latititude and and longitude to a copy of the dataframe, filter out the NAs from
  #these results, and then convert convert to sf, with point positions indicated in the
  #geometry column
  mutated <- df %>% mutate(extracted_lat = as.double(latitude),
                      extracted_lon = as.double(longitude))
  
  #remove rows with NAs for latitude or longitude, or with values well outside of Detroit
  filtered <- mutated %>%
    filter(!is.na(extracted_lat) & !is.na(extracted_lon)) %>%
    filter(41 < extracted_lat & extracted_lat < 44 & -85 < extracted_lon & extracted_lon < -81)
    
  #create a dataframe from the items that have been filtered out
  result_coord_na <- setdiff(mutated, filtered)
  
  #create sf objects from the rows with usable latitude and longitude information
  result_sf <- st_as_sf(filtered, coords = c("extracted_lon", "extracted_lat"), crs = 4326)
    
  return(list(result_sf, result_coord_na))
}
#apply the function to the five datasets for which the data was not loaded as a simple features dataframe, thus producing a list of two dataframes for each of the datasets, the first element of the list a simple features data frame and the second element a dataframe with the instances for which it was not possible to convert to simple features
blight_violations_split <- add_sf_point(blight_violations, "Violation Location")
dismantle_permits_split <- add_sf_point(dismantle_permits, "Permit Location")
crime_to_12062016_split <- add_sf_point(crime_to_12062016, "LOCATION")
crime_12062016_to_03192018_split <- add_sf_point(crime_12062016_to_03192018, "Location")
improve_detroit_issues_split <- add_sf_point(improve_detroit_issues, "Location")

We now consider the data for which we do not yet have position data, and complete the information as well as we reasonably can, using the Google api and a function, geocode_pause, that handles some of api’s quirks.

#the portino of the downloaded blight citations data, for which we do not have
blight_vio_na <- blight_violations_split[[2]]
#remove the rows for which geocoding is not likely to prodoce reliable results
useful <- blight_vio_na %>% filter(!is.na(`Violation Street Name`), 
                                   `Violation Street Number` > 0, 
                                   !is.na(`Violation Zip Code`))
#create a column of addresses to be used in geocoding
useful <- useful %>% 
  mutate(complete_address = paste(`Violation Street Number`, " ", `Violation Street Name`, ", ",
                                  "Detroit, Michigan", " ", `Violation Zip Code`, sep = ""))
#function makes a maximum 6 attempts to geocode the given address using the Google API, with a pause of 1 second between attempts. We will use the function for the other datasets as well.
geocode_pause <- function(address) {
  for (index in 1:6) {
    Sys.sleep(1)
    location <- ggmap::geocode(address)
    if (!is.na(location$lon)) {
      return(location)
    }
  }
}
#apply geocode_pause to each of the elements of the complete_addresse column and place the result in a new column, in which each entry is a data frame 
useful <- useful %>% mutate(location = map(complete_address, geocode_pause))

#save to disc, to avoid avoid the need to geocode these addresses again when we rerun the analysis
write_rds(useful, "./data/blight_violations_geocodes.rds")

The geocoding has returned a data frame for each of the addresses. We thus need to unpack the elements of the location column, each of which is a data frame.

#read blight_violations_geocodes as a tibble
blight_violations_geocodes <- read_rds("./data/blight_violations_geocodes.rds")
#function for removing the instances for which geocoding failed (for which the value in the location column is NULLL). We will use this function for all of the geocoded data frames.
remove_null_locations <- function(df) {
  #identify the rows for which the value in the location column is NULL
  null_rows <- list()
  for (index in 1:nrow(df)) {
    if (is.null(df$location[[index]])) {
      null_rows <- c(null_rows, index)
    }
  }
  #remove the rows for which the value of the location column is NULL
  df <- df[-as.integer(null_rows),]
}
blight_violations_geocodes <- remove_null_locations(blight_violations_geocodes)
#With blight_violations_geocodes a tibble, we can apply tidyr::unnest(), which will place the latitude and longitude in columns labelled "lat" and "lon".
blight_violations_geocodes <- blight_violations_geocodes %>% unnest(location)
#fill in the `Violation Latitute` and `Violation Longitude` data frames, which alread exist in the blight_violations data frame
blight_violations_geocodes <- blight_violations_geocodes %>%
  mutate(`Violation Latitude` = lat,
         `Violation Longitude` = lon)
#cut out some columns that have been added
blight_violations_geocodes <- blight_violations_geocodes %>% 
  select(-extracted_lat, -extracted_lon, -complete_address)
#put the position information into a simple features format (which will remove the "lat" and "lon" columns)
blight_violations_geocodes_sf <- st_as_sf(blight_violations_geocodes, 
                                          coords = c("lon", "lat"),
                                          crs = 4326)
#combine the results with the previously generated sf data
blight_violations_sf <- rbind(blight_violations_split[[1]], blight_violations_geocodes_sf)
rm(blight_vio_na, blight_violations, blight_violations_geocodes, 
   blight_violations_geocodes_sf, blight_violations_split, useful)
#the dismantle permits for which position data (latitude and longitude) is missing
dismantle_permits_split_na <- dismantle_permits_split[[2]]
#remove the last two columns, which were not contained in the original dismantle_permits datastet
dismantle_permits_split_na <- dismantle_permits_split_na %>% 
  select(-extracted_lat, -extracted_lon)
#geocode the items in dismantle_permits_split_na, using the address column and the function geocode_pause, which makes a maximum of six attempts for each item. The result is list of dataframes in the location column.
dismantle_permits_split_geocode <- dismantle_permits_split_na %>%
  mutate(location = map(str_c(`Site Address`, ", Detroit, Michigan"), geocode_pause))

#write the results of the geocoding to disk, to avoid having to repeat the geocoding when rerunning the analysis.
write_rds(dismantle_permits_split_geocode, "./data/dismantle_permits_geocodes.rds")

rm(dismantle_permits_split_na)
#load the geocoded data frame into R
dismantle_permits_split_geocode <- read_rds("./data/dismantle_permits_geocodes.rds")
#use the remove_null_locations() to remove the rows for which geocoding failed and then parse the information  in the dataframes in the location column into two new columns, lat and lan
dismantle_permits_split_geocode <- 
  remove_null_locations(dismantle_permits_split_geocode) %>%
  unnest(location)
#convert to a simple features (sf) data frame, using the latititudes and longitudes
dismantle_permits_geocode_sf <- st_as_sf(dismantle_permits_split_geocode, 
                                          coords = c("lon", "lat"),
                                          crs = 4326)
#append this simple features dataframe to the dataframe for which we already had usable positions
dismantle_permits_sf <- rbind(dismantle_permits_split[[1]], dismantle_permits_geocode_sf)
rm(dismantle_permits_split_geocode, dismantle_permits_geocode_sf, dismantle_permits, dismantle_permits_split, dismantle_permits_split_na)

We now fill-in the missing position information for the dataset for crimes up to 12-06-2016

#return to the older crime data
crime_to_12062016_leftovers <- crime_to_12062016_split[[2]]
#cut out the addresses that begin with "00"
crime_to_12062016_leftovers <- crime_to_12062016_leftovers %>% 
  filter(str_sub(LOCATION, 1, 2) != "00")
#filter out some obviously useless addresses, with few characters before the first "("
crime_to_12062016_leftovers <- crime_to_12062016_leftovers %>% 
  filter(!str_locate(LOCATION, "\\(")[,1] %in% 1:13)
#remove the two columns that were added earlier
crime_to_12062016_leftovers <- crime_to_12062016_leftovers %>% 
  select(-extracted_lat, -extracted_lon)
#create a column for use in geocoding
crime_to_12062016_leftovers <- crime_to_12062016_leftovers %>% 
  mutate(extracted_address = str_c(str_sub(LOCATION, 1, 
                                           str_locate(LOCATION, "\\(")[,1] - 2),
                                                      ", Detroit, Michigan"))
#geocode the elements of extracted_address, using the function geocode_pause
crime_to_12062016_leftovers_geocode <- crime_to_12062016_leftovers %>% 
  mutate(location = map(extracted_address, geocode_pause))

#save the results, to avoid having to geocode again when rerunning the analysis
write_rds(crime_to_12062016_leftovers_geocode, "./data/crime_to_12062016_leftovers_geocode.rds")
crime_to_12062016_leftovers_geocode <- read_rds("./data/crime_to_12062016_leftovers_geocode.rds")
#cut out the column we used for geocoding
crime_to_12062016_leftovers_geocode <- 
  crime_to_12062016_leftovers_geocode %>% select(-extracted_address)
  
#cut out of the geocode failures and put the location information into the columns lat and lon
crime_to_12062016_leftovers_geocode <- 
  remove_null_locations(crime_to_12062016_leftovers_geocode) %>%
  unnest(location)
#create a simple features (sf) object, using the latititudes and longitudes
crime_to_12062016_leftovers_sf <- st_as_sf(crime_to_12062016_leftovers_geocode, 
                                          coords = c("lon", "lat"),
                                          crs = 4326)
#append this simple features dataframe to the dataframe for which we already had locations
crime_to_12062016_sf <- rbind(crime_to_12062016_split[[1]], crime_to_12062016_leftovers_sf)
rm(crime_to_12062016, crime_to_12062016_leftovers_geocode, crime_to_12062016_leftovers_sf, crime_to_12062016_leftovers, crime_to_12062016_split)
#consider the examples in the recent crime data for which the conversion to sf didn't work, remove the two columns that we have added, and create and address column for geocoding
crime_12062016_to_03192018_leftovers <- crime_12062016_to_03192018_split[[2]] %>%
  select(-extracted_lat, -extracted_lon) %>%
  mutate(extracted_address = str_c(`Incident Address`, ", Detroit, Michigan"))
crime_12062016_to_03192018_geocode <- crime_12062016_to_03192018_leftovers %>% 
  mutate(location = map(extracted_address, geocode_pause))

write_rds(crime_12062016_to_03192018_geocode, "./data/crime_12062016_to_03192018_geocode.rds")
crime_12062016_to_03192018_geocode <- read_rds("./data/crime_12062016_to_03192018_geocode.rds") %>%
  select(-extracted_address)
#remove the rows for which the value of location is NULL and then unnest the remaining locations
crime_12062016_to_03192018_geocode <- 
  remove_null_locations(crime_12062016_to_03192018_geocode) %>%
  unnest(location)
#convert the dataframe to a simple features set
crime_12062016_to_03192018_sf <- st_as_sf(crime_12062016_to_03192018_geocode, 
                                          coords = c("lon", "lat"),
                                          crs = 4326)  
#combine the geocoded data with the sf dataframe created earlier
crime_12062016_to_03192018 <- rbind(crime_12062016_to_03192018_split[[1]], crime_12062016_to_03192018_sf)
rm(crime_12062016_to_03192018_split, crime_12062016_to_03192018_geocode, crime_12062016_to_03192018_leftovers, crime_12062016_to_03192018_sf)
#geocode the one item in the Improve Detroit Issues data for which the given coordinates were obviously incorrect, and then convert to an sf object. If geocoding fails, run this bit again
improve_detroit_issues_leftover_sf <- improve_detroit_issues_split[[2]] %>%
  select(-extracted_lat, -extracted_lon) %>%
  mutate(location = map(Address, geocode_pause)) %>%
  unnest(location) %>% 
  st_as_sf(coords = c("lon", "lat"), crs = 4326)  
Error in eval(lhs, parent, parent) : 
  object 'improve_detroit_issues_split' not found

We begin the assignment of labels to the buidings: blighted or not blighted. Buildings will be represented by parcels that have or have had buildings on them, whether by being so represented as in the parcels_sf data frame as including structures or in the dismantle permits dataframe as having had a dismante permit associated with it, thus suggesting that there was a building on the parcel.

We will use parcel numbers to refer to the parcels. This works because parcelnum column contains no repeats over different rows (see below, in which duplicate_parcel_numbers_in_parcel_data has zero rows).

#As per above, following returns an empty data frame
duplicate_parcel_numbers_in_parcel_data <- 
  parcel_sf %>%
  group_by(parcelnum) %>% 
  mutate(n = n()) %>%
  ungroup() %>% 
  filter(n > 1)
duplicate_parcel_numbers_in_parcel_data
Simple feature collection with 78 features and 38 fields
geometry type:  MULTIPOLYGON
dimension:      XY
bbox:           xmin: -83.17034 ymin: 42.32219 xmax: -83.0055 ymax: 42.4416
epsg (SRID):    4326
proj4string:    +proj=longlat +ellps=WGS84 +no_defs
rm(duplicate_parcel_numbers_in_parcel_data)

The dismantle permits data, however, may seem less clean than the parcel_sf, as it contains repetitions of the parcel numbers that correspond to different addresses that would refer, in some cases, to distinct locations. (It also indicates that a few individual locatations, identified with addresses, had more than one associated dismantle permit. This need not be problematic—a permit could expire before the work is carried out, or there could be more than one structure on a parcel.) These repetitions are in duplicate_parcel_numbers_over_distinct_addresses, which contains 260 rows. I should also note that, in most of these cases with duplicate parcel numbers (and addresses indicating different locations), the recorded latitude and longitude are identical. We can thus infer that some of this location information is incorrect.

dup_par_num_in_dismantle_data <-
  dismantle_permits_sf %>%
  group_by(`Parcel Number`) %>% 
  mutate(n = n()) %>%
  ungroup() %>% 
  filter(n > 1) %>%
  select(`Parcel Number`, `Site Address`)
as.data.frame(dup_par_num_in_dismantle_data)
rm(dup_par_num_in_dismantle_data)
#parcel numbers in the dismantle permits data that are distributed over disinct addresseses
dup_par_num_over_distinct_addresses <- 
  dismantle_permits_sf %>%
  group_by(`Parcel Number`) %>%
  mutate(parcel_number_occurances = n()) %>%
  ungroup() %>%
  filter(parcel_number_occurances > 1) %>%
  select(`Parcel Number`, `Site Address`, parcel_number_occurances) %>%
  group_by(`Parcel Number`, `Site Address`) %>%
  mutate(m = n()) %>%
  filter(m < parcel_number_occurances) %>%
  arrange(`Parcel Number`)
as.data.frame(dup_par_num_over_distinct_addresses)
rm(dup_par_num_over_distinct_addresses)

Some of repeats of the parcel numbers would seem to correspond to the some location (with the addresses recorded somewhat differently), while others would not. The number of rows in question is relatively small (272), so I will ignore the issue for now. (I will eventually either remove this data are attempt to attache the correct location information.)

#note that the following removes rows with duplicate parcels
#duplicate_parcel_numbers %>% distinct(parcelnum, .keep_all = TRUE)

parcel_join_sf_parcel_first <- 
  full_join(parcel_sf %>% select(parcelnum),
            dismantle_permits_sf %>% as.data.frame() %>% select(`Parcel Number`),
            c("parcelnum" = "Parcel Number")) %>%
  arrange(`Parcel Number`)

parcel_join_sf_dismantle_first <-
  full_join(dismantle_permits_sf %>% select(`Parcel Number`), 
            parcel_sf %>% as.data.frame() %>% select(parcelnum),
            c("Parcel Number" = "parcelnum")) %>%
  arrange(`Parcel Number`)

st_crs(parcel_sf)
st_crs(dismantle_permits_sf)

#Both of these yield an EPSG of 4326. Nethereless, the follow step seems necessary.

st_crs(dismantle_permits_sf) <- st_crs(parcel_sf)

temp <- st_join(dismantle_permits_sf, parcel_sf, join = st_within)
  
temp2 <- temp %>% filter(`Parcel Number` != parcelnum)

temp2 <- temp2 %>% select(`Parcel Number`, parcelnum, `Site Address`, address)


#note that objectid in parcel_sf has no NA values, and that objectid is a key in parcel_sf
parcel_sf %>% as.data.frame() %>% filter(is.na(objectid))
parcel_sf %>% count(objectid) %>% filter(n > 1)

#note that `Permit Number` is a also a key, for dismantle_permits_sf
dismantle_permits_sf %>% as.data.frame() %>% filter(is.na(`Permit Number`))
dismantle_permits_sf %>% count(`Permit Number`) %>% filter(n > 1)

#with the above in mind, we examine the NA values for these columns in our full join, beginning with objectid in parcel_sf. The idea is that any NA value for objectid in parcel_join would correspond to a parcel in the dismantle permits dataset that is either not reflected in the parcels dataset or for which there is a flaw in the data.
parcel_join %>% filter(is.na(objectid))

dismantle_permits_sf %>% filter(`Parcel Number` == "22108512.")

#dismantled_structures <- initial_join %>% filter(!is.na(`Permit Number`))

parcel_sf %>% filter(parcelnum == "22108512.")

parcel_tmp <- blight_violations_sf[c(1, 2),]

st_distance(parcel_tmp)

m_list <- mapply(st_distance, blight_violations_sf$geometry[1], fred$geometry)

dismantle_permits_sf %>% as.data.frame() %>% filter(is.na(`Parcel Number`))

temp4 <- st_distance(parcel_sf[195099,], 
            blight_violations_sf[22233:22255,])

st_crs(blight_violations_sf) <- st_crs(parcel_sf)

plot(blight_violations_sf, max.plot = 1)

Maps:

library(ggmap)

ggplot(blight_violations_sf %>% select(geometry)) +
  geom_sf() + 
  geom_density2d(data = blight_violations_sf %>% select(geometry))


ggplot(data=xy.sf) +
    geom_sf() +
    geom_density2d(data=xy.sf, aes(x=x,y=y,colour=..level..))


detroit_gg <- get_map("Detroit", maptype = "toner-lite",
                      zoom = 11)

ggmap(detroit_gg)
LS0tCnRpdGxlOiAiQmxpZ2h0IFByZWRpY3Rpb25zIGZvciBEZXRyb2l0IgpvdXRwdXQ6IGh0bWxfbm90ZWJvb2sKLS0tCgpJbiB0aGlzIHByb2plY3QsIEkgd2lsbCBhdHRlbXB0IHRvIHByZWRpY3Qgd2hldGhlciwgZm9yIGFueSBnaXZlbiBwYXJjZWwgaW4gRGV0cm9pdCB3aXRoIGEgYnVpbGRpbmcgb24gaXQsIHdoZXRoZXIgYSBidWlsZGluZyBvbiB0aGF0IHBhcmNlbCB3aWxsIGJlIGJlIHRhcmdldHRlZCBmb3IgZGVtb2x0aW9uLiBQb3RlbnRpYWwgcHJlZGljdG9ycywgZG93bmxvYWRlZCBmcm9tICBodHRwczovL2RhdGEuZGV0cm9pdG1pLmdvdi8sIGluY2x1ZGUgY2l0YXRpb25zIHJlbGF0YXRlZCB0byB0aGUgYnVpbGRpbmcsIGNyaW1lLCBhbmQgY29tcGxhaW50cyBjb25jZXJuaW5nIHRoZSBidWlsZGluZyByZWxhdGVkIHRvIGJsaWdodC4gVGhlIHByb2JqZWN0IGlzIGN1cnJlbnRseSBhdCB0aGUgZGF0YSBjbGVhbmluZyBzdGFnZSwgYW5kIEkgbWF5IGFkZCBzb21lIG90aGVyIGRhdGEgdG8gdGhlIHByb2plY3QuIFNvIGZhciwgSSBhbSB1c2luZyBhYm91dCAzR0Igb2YgZGF0YS4KCgpgYGB7cn0KbGlicmFyeSh0aWR5dmVyc2UpCmxpYnJhcnkoc2YpCmxpYnJhcnkoZ2dtYXApCmxpYnJhcnkobHdnZW9tKQoKI3JlY29yZGVkIHZpb2xhdGlvbnMgYXNzb2NpYXRlZCB3aXRoIGJsaWdodCAoZS5nLiB1bmtlbXB0IHByb3BlcnRpZXMpCmJsaWdodF92aW9sYXRpb25zIDwtIHJlYWRfY3N2KCIuL2RhdGEvQmxpZ2h0X1Zpb2xhdGlvbnNfM18xOV8yMDE4LmNzdiIsIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICBndWVzc19tYXggPSAxMF42KQoKI3JlYWQgdGhlIGRvd25sb2FkZWQgZmlsZSBmb3IgYWxsIHRoZSBidWlsZGluZyBwZXJtaXRzIGFuZCB0aGVuIGZpbHRlciBvdXQgdGhlIHBlcm1pdHMgZm9yIGRpc21hbnRsaW5nCmRpc21hbnRsZV9wZXJtaXRzIDwtIHJlYWRfY3N2KCIuL2RhdGEvQnVpbGRpbmdfUGVybWl0c18zXzE5XzIwMTguY3N2IiwgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgZ3Vlc3NfbWF4ID0gMTBeNikgJT4lCiAgZmlsdGVyKGBCdWlsZGluZyBQZXJtaXQgVHlwZWAgPT0gIkRpc21hbnRsZSIpCiAgCiN0aGUgZmlsZXMgdGhhdCBjb250YWluIHRoZSBjcmltZSBkYXRhCmNyaW1lX3RvXzEyMDYyMDE2IDwtIAogIHJlYWRfY3N2KCIuL2RhdGEvRFBEX19BbGxfQ3JpbWVfSW5jaWRlbnRzX19KYW51YXJ5XzFfXzIwMDlfLV9EZWNlbWJlcl82X18yMDE2LmNzdiIsCiAgICAgICAgICAgZ3Vlc3NfbWF4ID0gMTBeNikKCmNyaW1lXzEyMDYyMDE2X3RvXzAzMTkyMDE4IDwtIAogIHJlYWRfY3N2KCIuL2RhdGEvRFBEX19BbGxfQ3JpbWVfSW5jaWRlbnRzX19EZWNlbWJlcl82X18yMDE2Xy1fM18xOV8yMDE4LmNzdiIsIAogICAgICAgICAgIGd1ZXNzX21heCA9IDEwXjYpCgojdGhlIDMxMSBzeXN0ZW0KaW1wcm92ZV9kZXRyb2l0X2lzc3VlcyA8LSByZWFkX2NzdigiLi9kYXRhL0ltcHJvdmVfRGV0cm9pdF9Jc3N1ZXNfM18xOV8yMDE4LmNzdiIsIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGd1ZXNzX21heCA9IDEwXjYpCgojdGhlIHNoYXBlZmlsZSByZXByZXNlbnRpbmcgRGV0cm9pdCBwYXJjZWxzLCByZWFkIGludG8gCnBhcmNlbF9zZiA8LSBzdF9yZWFkKCIuL2RhdGEvUGFyY2VsIE1hcCIpCgpgYGAKCkZvciBhbGwgb2YgdGhlIGRvd25sb2FkZWQgZGF0YXNldHMgb3RoZXIgdGhhbiB0aGUgcGFyY2VscyBkYXRhc2V0LCB3ZSBleHRyYWN0IGV4dHJhY3QgdGhlIHVzYWJsZSBsYXR1dHVkZSBhbmQgbG9uZ2l0dWRlIHZhbHVlcyBhbmQgdGhlbiB1c2UgdGhpcyBpbmZvcm1hdGlvbiB0byBmb3JtIHNpbXBsZSBmZWF0dXJlcyAoc2YpIG9iamVjdHMuIFJvd3Mgd2l0aCBvYnZpb3VzbHkgaW5jb3JyZWN0IHZhbHVlcywgb3IgdmFsdWVzIHRoYXQgd291bGQgcmVwcmVzZW50IHBvc2l0aW9ucyB3ZWxsIG91dHNpZGUgRGV0cm9pdCwgYXJlIGZpbHRlcmVkIG91dCwgdG9nZXRoZXIgd2l0aCByb3dzIGZvciB3aGljaCB0aGUgbGF0aXR1ZGUgb3IgbG9uZ2l0dWRlIGRhdGEgaXMgbWlzc2luZy4KCmBgYHtyfQoKI2Z1bmN0aW9uIGZvciBjb252ZXJ0aW5nIHRoZSBwb3NpdGlvbiAoY2hhcmFjdGVyKSBjb2x1bW4gaW50byBhIGNvbHVtbiBvZiBwb2ludHMgaW4gdGhlIHNpbXBsZSBmZWF0dXJlcyAoc2YpIGZyYW1ld29yay4KYWRkX3NmX3BvaW50IDwtIGZ1bmN0aW9uKGRmLCBjb2x1bW4pIHsKICAKICAjZXh0cmFjdCB0aGUgbGF0aXR1ZGUgYW5kIGxvbmdpdHVkZSBmcm9tIHRoZSBzdHJpbmcgY29sdW1uIHRoYXQgY29udGFpbnMgYm90aC4gV2l0aCB0aGUgcGFyZW50aGVzZXMKICAjbG9jYXRlZCBmcm9tIHRoZSBlbmQgb2YgdGhlIHN0cmluZ3MsIGl0IGlzIHBvc3NpYmxlIHRvIHVzZSB0aGUgdGhlIHNhbWUgZnVuY3Rpb24gZm9yIGFsbCBmaXZlIG9mIAogICN0aGUgZGF0YXNldHMgZm9yIHdoaWNoIHdlIG5lZWQgdG8gZXh0cmFjdCB0aGlzIGluZm9ybWF0aW9uLgogIGxhdGl0dWRlIDwtIHN0cl9zdWIoZGZbW2NvbHVtbl1dLCAKICAgICAgICAgICAgICAgICAgICAgIHN0cmluZ2k6OnN0cmlfbG9jYXRlX2xhc3RfZml4ZWQoZGZbW2NvbHVtbl1dLCAiKCIpWywyXSArIDEsCiAgICAgICAgICAgICAgICAgICAgICBzdHJpbmdpOjpzdHJpX2xvY2F0ZV9sYXN0X2ZpeGVkKGRmW1tjb2x1bW5dXSwgIiwiKVssMV0gLSAxKQogIGxvbmdpdHVkZSA8LSBzdHJfc3ViKGRmW1tjb2x1bW5dXSwgCiAgICAgICAgICAgICAgICAgICAgICAgc3RyaW5naTo6c3RyaV9sb2NhdGVfbGFzdF9maXhlZChkZltbY29sdW1uXV0sICIsICIpWywyXSArIDEsIAogICAgICAgICAgICAgICAgICAgICAgIHN0cmluZ2k6OnN0cmlfbG9jYXRlX2xhc3RfZml4ZWQoZGZbW2NvbHVtbl1dLCAiKSIpWywxXSAtIDEpCiAgCiAgI2FkZCB0aGUgbGF0aXRpdHVkZSBhbmQgYW5kIGxvbmdpdHVkZSB0byBhIGNvcHkgb2YgdGhlIGRhdGFmcmFtZSwgZmlsdGVyIG91dCB0aGUgTkFzIGZyb20KICAjdGhlc2UgcmVzdWx0cywgYW5kIHRoZW4gY29udmVydCBjb252ZXJ0IHRvIHNmLCB3aXRoIHBvaW50IHBvc2l0aW9ucyBpbmRpY2F0ZWQgaW4gdGhlCiAgI2dlb21ldHJ5IGNvbHVtbgogIG11dGF0ZWQgPC0gZGYgJT4lIG11dGF0ZShleHRyYWN0ZWRfbGF0ID0gYXMuZG91YmxlKGxhdGl0dWRlKSwKICAgICAgICAgICAgICAgICAgICAgIGV4dHJhY3RlZF9sb24gPSBhcy5kb3VibGUobG9uZ2l0dWRlKSkKICAKICAjcmVtb3ZlIHJvd3Mgd2l0aCBOQXMgZm9yIGxhdGl0dWRlIG9yIGxvbmdpdHVkZSwgb3Igd2l0aCB2YWx1ZXMgd2VsbCBvdXRzaWRlIG9mIERldHJvaXQKICBmaWx0ZXJlZCA8LSBtdXRhdGVkICU+JQogICAgZmlsdGVyKCFpcy5uYShleHRyYWN0ZWRfbGF0KSAmICFpcy5uYShleHRyYWN0ZWRfbG9uKSkgJT4lCiAgICBmaWx0ZXIoNDEgPCBleHRyYWN0ZWRfbGF0ICYgZXh0cmFjdGVkX2xhdCA8IDQ0ICYgLTg1IDwgZXh0cmFjdGVkX2xvbiAmIGV4dHJhY3RlZF9sb24gPCAtODEpCiAgICAKICAjY3JlYXRlIGEgZGF0YWZyYW1lIGZyb20gdGhlIGl0ZW1zIHRoYXQgaGF2ZSBiZWVuIGZpbHRlcmVkIG91dAogIHJlc3VsdF9jb29yZF9uYSA8LSBzZXRkaWZmKG11dGF0ZWQsIGZpbHRlcmVkKQogIAogICNjcmVhdGUgc2Ygb2JqZWN0cyBmcm9tIHRoZSByb3dzIHdpdGggdXNhYmxlIGxhdGl0dWRlIGFuZCBsb25naXR1ZGUgaW5mb3JtYXRpb24KICByZXN1bHRfc2YgPC0gc3RfYXNfc2YoZmlsdGVyZWQsIGNvb3JkcyA9IGMoImV4dHJhY3RlZF9sb24iLCAiZXh0cmFjdGVkX2xhdCIpLCBjcnMgPSA0MzI2KQogICAgCiAgcmV0dXJuKGxpc3QocmVzdWx0X3NmLCByZXN1bHRfY29vcmRfbmEpKQp9CgojYXBwbHkgdGhlIGZ1bmN0aW9uIHRvIHRoZSBmaXZlIGRhdGFzZXRzIGZvciB3aGljaCB0aGUgZGF0YSB3YXMgbm90IGxvYWRlZCBhcyBhIHNpbXBsZSBmZWF0dXJlcyBkYXRhZnJhbWUsIHRodXMgcHJvZHVjaW5nIGEgbGlzdCBvZiB0d28gZGF0YWZyYW1lcyBmb3IgZWFjaCBvZiB0aGUgZGF0YXNldHMsIHRoZSBmaXJzdCBlbGVtZW50IG9mIHRoZSBsaXN0IGEgc2ltcGxlIGZlYXR1cmVzIGRhdGEgZnJhbWUgYW5kIHRoZSBzZWNvbmQgZWxlbWVudCBhIGRhdGFmcmFtZSB3aXRoIHRoZSBpbnN0YW5jZXMgZm9yIHdoaWNoIGl0IHdhcyBub3QgcG9zc2libGUgdG8gY29udmVydCB0byBzaW1wbGUgZmVhdHVyZXMKYmxpZ2h0X3Zpb2xhdGlvbnNfc3BsaXQgPC0gYWRkX3NmX3BvaW50KGJsaWdodF92aW9sYXRpb25zLCAiVmlvbGF0aW9uIExvY2F0aW9uIikKCmRpc21hbnRsZV9wZXJtaXRzX3NwbGl0IDwtIGFkZF9zZl9wb2ludChkaXNtYW50bGVfcGVybWl0cywgIlBlcm1pdCBMb2NhdGlvbiIpCgpjcmltZV90b18xMjA2MjAxNl9zcGxpdCA8LSBhZGRfc2ZfcG9pbnQoY3JpbWVfdG9fMTIwNjIwMTYsICJMT0NBVElPTiIpCgpjcmltZV8xMjA2MjAxNl90b18wMzE5MjAxOF9zcGxpdCA8LSBhZGRfc2ZfcG9pbnQoY3JpbWVfMTIwNjIwMTZfdG9fMDMxOTIwMTgsICJMb2NhdGlvbiIpCgppbXByb3ZlX2RldHJvaXRfaXNzdWVzX3NwbGl0IDwtIGFkZF9zZl9wb2ludChpbXByb3ZlX2RldHJvaXRfaXNzdWVzLCAiTG9jYXRpb24iKQoKYGBgCgpXZSBub3cgY29uc2lkZXIgdGhlIGRhdGEgZm9yIHdoaWNoIHdlIGRvIG5vdCB5ZXQgaGF2ZSBwb3NpdGlvbiBkYXRhLCBhbmQgY29tcGxldGUgdGhlIGluZm9ybWF0aW9uIGFzIHdlbGwgYXMgd2UgcmVhc29uYWJseSBjYW4sIHVzaW5nIHRoZSBHb29nbGUgYXBpIGFuZCBhIGZ1bmN0aW9uLCBgZ2VvY29kZV9wYXVzZWAsIHRoYXQgaGFuZGxlcyBzb21lIG9mIGFwaSdzIHF1aXJrcy4KCmBgYHtyfQoKI3RoZSBwb3J0aW5vIG9mIHRoZSBkb3dubG9hZGVkIGJsaWdodCBjaXRhdGlvbnMgZGF0YSwgZm9yIHdoaWNoIHdlIGRvIG5vdCBoYXZlCmJsaWdodF92aW9fbmEgPC0gYmxpZ2h0X3Zpb2xhdGlvbnNfc3BsaXRbWzJdXQoKI3JlbW92ZSB0aGUgcm93cyBmb3Igd2hpY2ggZ2VvY29kaW5nIGlzIG5vdCBsaWtlbHkgdG8gcHJvZG9jZSByZWxpYWJsZSByZXN1bHRzCnVzZWZ1bCA8LSBibGlnaHRfdmlvX25hICU+JSBmaWx0ZXIoIWlzLm5hKGBWaW9sYXRpb24gU3RyZWV0IE5hbWVgKSwgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgYFZpb2xhdGlvbiBTdHJlZXQgTnVtYmVyYCA+IDAsIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICFpcy5uYShgVmlvbGF0aW9uIFppcCBDb2RlYCkpCgojY3JlYXRlIGEgY29sdW1uIG9mIGFkZHJlc3NlcyB0byBiZSB1c2VkIGluIGdlb2NvZGluZwp1c2VmdWwgPC0gdXNlZnVsICU+JSAKICBtdXRhdGUoY29tcGxldGVfYWRkcmVzcyA9IHBhc3RlKGBWaW9sYXRpb24gU3RyZWV0IE51bWJlcmAsICIgIiwgYFZpb2xhdGlvbiBTdHJlZXQgTmFtZWAsICIsICIsCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAiRGV0cm9pdCwgTWljaGlnYW4iLCAiICIsIGBWaW9sYXRpb24gWmlwIENvZGVgLCBzZXAgPSAiIikpCgojZnVuY3Rpb24gbWFrZXMgYSBtYXhpbXVtIDYgYXR0ZW1wdHMgdG8gZ2VvY29kZSB0aGUgZ2l2ZW4gYWRkcmVzcyB1c2luZyB0aGUgR29vZ2xlIEFQSSwgd2l0aCBhIHBhdXNlIG9mIDEgc2Vjb25kIGJldHdlZW4gYXR0ZW1wdHMuIFdlIHdpbGwgdXNlIHRoZSBmdW5jdGlvbiBmb3IgdGhlIG90aGVyIGRhdGFzZXRzIGFzIHdlbGwuCmdlb2NvZGVfcGF1c2UgPC0gZnVuY3Rpb24oYWRkcmVzcykgewogIGZvciAoaW5kZXggaW4gMTo2KSB7CiAgICBTeXMuc2xlZXAoMSkKICAgIGxvY2F0aW9uIDwtIGdnbWFwOjpnZW9jb2RlKGFkZHJlc3MpCiAgICBpZiAoIWlzLm5hKGxvY2F0aW9uJGxvbikpIHsKICAgICAgcmV0dXJuKGxvY2F0aW9uKQogICAgfQogIH0KfQpgYGAKCgpgYGB7ciwgZXZhbCA9IEZBTFNFfQojYXBwbHkgZ2VvY29kZV9wYXVzZSB0byBlYWNoIG9mIHRoZSBlbGVtZW50cyBvZiB0aGUgY29tcGxldGVfYWRkcmVzc2UgY29sdW1uIGFuZCBwbGFjZSB0aGUgcmVzdWx0IGluIGEgbmV3IGNvbHVtbiwgaW4gd2hpY2ggZWFjaCBlbnRyeSBpcyBhIGRhdGEgZnJhbWUgCnVzZWZ1bCA8LSB1c2VmdWwgJT4lIG11dGF0ZShsb2NhdGlvbiA9IG1hcChjb21wbGV0ZV9hZGRyZXNzLCBnZW9jb2RlX3BhdXNlKSkKCiNzYXZlIHRvIGRpc2MsIHRvIGF2b2lkIGF2b2lkIHRoZSBuZWVkIHRvIGdlb2NvZGUgdGhlc2UgYWRkcmVzc2VzIGFnYWluIHdoZW4gd2UgcmVydW4gdGhlIGFuYWx5c2lzCndyaXRlX3Jkcyh1c2VmdWwsICIuL2RhdGEvYmxpZ2h0X3Zpb2xhdGlvbnNfZ2VvY29kZXMucmRzIikKCmBgYAoKVGhlIGdlb2NvZGluZyBoYXMgcmV0dXJuZWQgYSBkYXRhIGZyYW1lIGZvciBlYWNoIG9mIHRoZSBhZGRyZXNzZXMuIFdlIHRodXMgbmVlZCB0byB1bnBhY2sgdGhlIGVsZW1lbnRzIG9mIHRoZSBsb2NhdGlvbiBjb2x1bW4sIGVhY2ggb2Ygd2hpY2ggaXMgYSBkYXRhIGZyYW1lLgoKYGBge3J9CiNyZWFkIGJsaWdodF92aW9sYXRpb25zX2dlb2NvZGVzIGFzIGEgdGliYmxlCmJsaWdodF92aW9sYXRpb25zX2dlb2NvZGVzIDwtIHJlYWRfcmRzKCIuL2RhdGEvYmxpZ2h0X3Zpb2xhdGlvbnNfZ2VvY29kZXMucmRzIikKCiNmdW5jdGlvbiBmb3IgcmVtb3ZpbmcgdGhlIGluc3RhbmNlcyBmb3Igd2hpY2ggZ2VvY29kaW5nIGZhaWxlZCAoZm9yIHdoaWNoIHRoZSB2YWx1ZSBpbiB0aGUgbG9jYXRpb24gY29sdW1uIGlzIE5VTExMKS4gV2Ugd2lsbCB1c2UgdGhpcyBmdW5jdGlvbiBmb3IgYWxsIG9mIHRoZSBnZW9jb2RlZCBkYXRhIGZyYW1lcy4KcmVtb3ZlX251bGxfbG9jYXRpb25zIDwtIGZ1bmN0aW9uKGRmKSB7CiAgI2lkZW50aWZ5IHRoZSByb3dzIGZvciB3aGljaCB0aGUgdmFsdWUgaW4gdGhlIGxvY2F0aW9uIGNvbHVtbiBpcyBOVUxMCiAgbnVsbF9yb3dzIDwtIGxpc3QoKQogIGZvciAoaW5kZXggaW4gMTpucm93KGRmKSkgewogICAgaWYgKGlzLm51bGwoZGYkbG9jYXRpb25bW2luZGV4XV0pKSB7CiAgICAgIG51bGxfcm93cyA8LSBjKG51bGxfcm93cywgaW5kZXgpCiAgICB9CiAgfQogICNyZW1vdmUgdGhlIHJvd3MgZm9yIHdoaWNoIHRoZSB2YWx1ZSBvZiB0aGUgbG9jYXRpb24gY29sdW1uIGlzIE5VTEwKICBkZiA8LSBkZlstYXMuaW50ZWdlcihudWxsX3Jvd3MpLF0KfQoKYmxpZ2h0X3Zpb2xhdGlvbnNfZ2VvY29kZXMgPC0gcmVtb3ZlX251bGxfbG9jYXRpb25zKGJsaWdodF92aW9sYXRpb25zX2dlb2NvZGVzKQoKI1dpdGggYmxpZ2h0X3Zpb2xhdGlvbnNfZ2VvY29kZXMgYSB0aWJibGUsIHdlIGNhbiBhcHBseSB0aWR5cjo6dW5uZXN0KCksIHdoaWNoIHdpbGwgcGxhY2UgdGhlIGxhdGl0dWRlIGFuZCBsb25naXR1ZGUgaW4gY29sdW1ucyBsYWJlbGxlZCAibGF0IiBhbmQgImxvbiIuCmJsaWdodF92aW9sYXRpb25zX2dlb2NvZGVzIDwtIGJsaWdodF92aW9sYXRpb25zX2dlb2NvZGVzICU+JSB1bm5lc3QobG9jYXRpb24pCgojZmlsbCBpbiB0aGUgYFZpb2xhdGlvbiBMYXRpdHV0ZWAgYW5kIGBWaW9sYXRpb24gTG9uZ2l0dWRlYCBkYXRhIGZyYW1lcywgd2hpY2ggYWxyZWFkIGV4aXN0IGluIHRoZSBibGlnaHRfdmlvbGF0aW9ucyBkYXRhIGZyYW1lCmJsaWdodF92aW9sYXRpb25zX2dlb2NvZGVzIDwtIGJsaWdodF92aW9sYXRpb25zX2dlb2NvZGVzICU+JQogIG11dGF0ZShgVmlvbGF0aW9uIExhdGl0dWRlYCA9IGxhdCwKICAgICAgICAgYFZpb2xhdGlvbiBMb25naXR1ZGVgID0gbG9uKQoKI2N1dCBvdXQgc29tZSBjb2x1bW5zIHRoYXQgaGF2ZSBiZWVuIGFkZGVkCmJsaWdodF92aW9sYXRpb25zX2dlb2NvZGVzIDwtIGJsaWdodF92aW9sYXRpb25zX2dlb2NvZGVzICU+JSAKICBzZWxlY3QoLWV4dHJhY3RlZF9sYXQsIC1leHRyYWN0ZWRfbG9uLCAtY29tcGxldGVfYWRkcmVzcykKCiNwdXQgdGhlIHBvc2l0aW9uIGluZm9ybWF0aW9uIGludG8gYSBzaW1wbGUgZmVhdHVyZXMgZm9ybWF0ICh3aGljaCB3aWxsIHJlbW92ZSB0aGUgImxhdCIgYW5kICJsb24iIGNvbHVtbnMpCmJsaWdodF92aW9sYXRpb25zX2dlb2NvZGVzX3NmIDwtIHN0X2FzX3NmKGJsaWdodF92aW9sYXRpb25zX2dlb2NvZGVzLCAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgY29vcmRzID0gYygibG9uIiwgImxhdCIpLAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBjcnMgPSA0MzI2KQoKI2NvbWJpbmUgdGhlIHJlc3VsdHMgd2l0aCB0aGUgcHJldmlvdXNseSBnZW5lcmF0ZWQgc2YgZGF0YQpibGlnaHRfdmlvbGF0aW9uc19zZiA8LSByYmluZChibGlnaHRfdmlvbGF0aW9uc19zcGxpdFtbMV1dLCBibGlnaHRfdmlvbGF0aW9uc19nZW9jb2Rlc19zZikKCnJtKGJsaWdodF92aW9fbmEsIGJsaWdodF92aW9sYXRpb25zLCBibGlnaHRfdmlvbGF0aW9uc19nZW9jb2RlcywgCiAgIGJsaWdodF92aW9sYXRpb25zX2dlb2NvZGVzX3NmLCBibGlnaHRfdmlvbGF0aW9uc19zcGxpdCwgdXNlZnVsKQoKYGBgCgpgYGB7cn0KCiN0aGUgZGlzbWFudGxlIHBlcm1pdHMgZm9yIHdoaWNoIHBvc2l0aW9uIGRhdGEgKGxhdGl0dWRlIGFuZCBsb25naXR1ZGUpIGlzIG1pc3NpbmcKZGlzbWFudGxlX3Blcm1pdHNfc3BsaXRfbmEgPC0gZGlzbWFudGxlX3Blcm1pdHNfc3BsaXRbWzJdXQoKI3JlbW92ZSB0aGUgbGFzdCB0d28gY29sdW1ucywgd2hpY2ggd2VyZSBub3QgY29udGFpbmVkIGluIHRoZSBvcmlnaW5hbCBkaXNtYW50bGVfcGVybWl0cyBkYXRhc3RldApkaXNtYW50bGVfcGVybWl0c19zcGxpdF9uYSA8LSBkaXNtYW50bGVfcGVybWl0c19zcGxpdF9uYSAlPiUgCiAgc2VsZWN0KC1leHRyYWN0ZWRfbGF0LCAtZXh0cmFjdGVkX2xvbikKCmBgYAoKCmBgYHtyLCBldmFsID0gRkFMU0V9CgojZ2VvY29kZSB0aGUgaXRlbXMgaW4gZGlzbWFudGxlX3Blcm1pdHNfc3BsaXRfbmEsIHVzaW5nIHRoZSBhZGRyZXNzIGNvbHVtbiBhbmQgdGhlIGZ1bmN0aW9uIGdlb2NvZGVfcGF1c2UsIHdoaWNoIG1ha2VzIGEgbWF4aW11bSBvZiBzaXggYXR0ZW1wdHMgZm9yIGVhY2ggaXRlbS4gVGhlIHJlc3VsdCBpcyBsaXN0IG9mIGRhdGFmcmFtZXMgaW4gdGhlIGxvY2F0aW9uIGNvbHVtbi4KZGlzbWFudGxlX3Blcm1pdHNfc3BsaXRfZ2VvY29kZSA8LSBkaXNtYW50bGVfcGVybWl0c19zcGxpdF9uYSAlPiUKICBtdXRhdGUobG9jYXRpb24gPSBtYXAoc3RyX2MoYFNpdGUgQWRkcmVzc2AsICIsIERldHJvaXQsIE1pY2hpZ2FuIiksIGdlb2NvZGVfcGF1c2UpKQoKI3dyaXRlIHRoZSByZXN1bHRzIG9mIHRoZSBnZW9jb2RpbmcgdG8gZGlzaywgdG8gYXZvaWQgaGF2aW5nIHRvIHJlcGVhdCB0aGUgZ2VvY29kaW5nIHdoZW4gcmVydW5uaW5nIHRoZSBhbmFseXNpcy4Kd3JpdGVfcmRzKGRpc21hbnRsZV9wZXJtaXRzX3NwbGl0X2dlb2NvZGUsICIuL2RhdGEvZGlzbWFudGxlX3Blcm1pdHNfZ2VvY29kZXMucmRzIikKCnJtKGRpc21hbnRsZV9wZXJtaXRzX3NwbGl0X25hKQoKYGBgCgoKYGBge3J9CiNsb2FkIHRoZSBnZW9jb2RlZCBkYXRhIGZyYW1lIGludG8gUgpkaXNtYW50bGVfcGVybWl0c19zcGxpdF9nZW9jb2RlIDwtIHJlYWRfcmRzKCIuL2RhdGEvZGlzbWFudGxlX3Blcm1pdHNfZ2VvY29kZXMucmRzIikKCiN1c2UgdGhlIHJlbW92ZV9udWxsX2xvY2F0aW9ucygpIHRvIHJlbW92ZSB0aGUgcm93cyBmb3Igd2hpY2ggZ2VvY29kaW5nIGZhaWxlZCBhbmQgdGhlbiBwYXJzZSB0aGUgaW5mb3JtYXRpb24gIGluIHRoZSBkYXRhZnJhbWVzIGluIHRoZSBsb2NhdGlvbiBjb2x1bW4gaW50byB0d28gbmV3IGNvbHVtbnMsIGxhdCBhbmQgbGFuCmRpc21hbnRsZV9wZXJtaXRzX3NwbGl0X2dlb2NvZGUgPC0gCiAgcmVtb3ZlX251bGxfbG9jYXRpb25zKGRpc21hbnRsZV9wZXJtaXRzX3NwbGl0X2dlb2NvZGUpICU+JQogIHVubmVzdChsb2NhdGlvbikKCiNjb252ZXJ0IHRvIGEgc2ltcGxlIGZlYXR1cmVzIChzZikgZGF0YSBmcmFtZSwgdXNpbmcgdGhlIGxhdGl0aXR1ZGVzIGFuZCBsb25naXR1ZGVzCmRpc21hbnRsZV9wZXJtaXRzX2dlb2NvZGVfc2YgPC0gc3RfYXNfc2YoZGlzbWFudGxlX3Blcm1pdHNfc3BsaXRfZ2VvY29kZSwgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGNvb3JkcyA9IGMoImxvbiIsICJsYXQiKSwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgY3JzID0gNDMyNikKCiNhcHBlbmQgdGhpcyBzaW1wbGUgZmVhdHVyZXMgZGF0YWZyYW1lIHRvIHRoZSBkYXRhZnJhbWUgZm9yIHdoaWNoIHdlIGFscmVhZHkgaGFkIHVzYWJsZSBwb3NpdGlvbnMKZGlzbWFudGxlX3Blcm1pdHNfc2YgPC0gcmJpbmQoZGlzbWFudGxlX3Blcm1pdHNfc3BsaXRbWzFdXSwgZGlzbWFudGxlX3Blcm1pdHNfZ2VvY29kZV9zZikKCnJtKGRpc21hbnRsZV9wZXJtaXRzX3NwbGl0X2dlb2NvZGUsIGRpc21hbnRsZV9wZXJtaXRzX2dlb2NvZGVfc2YsIGRpc21hbnRsZV9wZXJtaXRzLCBkaXNtYW50bGVfcGVybWl0c19zcGxpdCwgZGlzbWFudGxlX3Blcm1pdHNfc3BsaXRfbmEpCgpgYGAKCldlIG5vdyBmaWxsLWluIHRoZSBtaXNzaW5nIHBvc2l0aW9uIGluZm9ybWF0aW9uIGZvciB0aGUgZGF0YXNldCBmb3IgY3JpbWVzIHVwIHRvIDEyLTA2LTIwMTYKCmBgYHtyfQoKI3JldHVybiB0byB0aGUgb2xkZXIgY3JpbWUgZGF0YQpjcmltZV90b18xMjA2MjAxNl9sZWZ0b3ZlcnMgPC0gY3JpbWVfdG9fMTIwNjIwMTZfc3BsaXRbWzJdXQoKI2N1dCBvdXQgdGhlIGFkZHJlc3NlcyB0aGF0IGJlZ2luIHdpdGggIjAwIgpjcmltZV90b18xMjA2MjAxNl9sZWZ0b3ZlcnMgPC0gY3JpbWVfdG9fMTIwNjIwMTZfbGVmdG92ZXJzICU+JSAKICBmaWx0ZXIoc3RyX3N1YihMT0NBVElPTiwgMSwgMikgIT0gIjAwIikKCiNmaWx0ZXIgb3V0IHNvbWUgb2J2aW91c2x5IHVzZWxlc3MgYWRkcmVzc2VzLCB3aXRoIGZldyBjaGFyYWN0ZXJzIGJlZm9yZSB0aGUgZmlyc3QgIigiCmNyaW1lX3RvXzEyMDYyMDE2X2xlZnRvdmVycyA8LSBjcmltZV90b18xMjA2MjAxNl9sZWZ0b3ZlcnMgJT4lIAogIGZpbHRlcighc3RyX2xvY2F0ZShMT0NBVElPTiwgIlxcKCIpWywxXSAlaW4lIDE6MTMpCgojcmVtb3ZlIHRoZSB0d28gY29sdW1ucyB0aGF0IHdlcmUgYWRkZWQgZWFybGllcgpjcmltZV90b18xMjA2MjAxNl9sZWZ0b3ZlcnMgPC0gY3JpbWVfdG9fMTIwNjIwMTZfbGVmdG92ZXJzICU+JSAKICBzZWxlY3QoLWV4dHJhY3RlZF9sYXQsIC1leHRyYWN0ZWRfbG9uKQoKI2NyZWF0ZSBhIGNvbHVtbiBmb3IgdXNlIGluIGdlb2NvZGluZwpjcmltZV90b18xMjA2MjAxNl9sZWZ0b3ZlcnMgPC0gY3JpbWVfdG9fMTIwNjIwMTZfbGVmdG92ZXJzICU+JSAKICBtdXRhdGUoZXh0cmFjdGVkX2FkZHJlc3MgPSBzdHJfYyhzdHJfc3ViKExPQ0FUSU9OLCAxLCAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHN0cl9sb2NhdGUoTE9DQVRJT04sICJcXCgiKVssMV0gLSAyKSwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIiwgRGV0cm9pdCwgTWljaGlnYW4iKSkKCmBgYAoKYGBge3IsIGV2YWwgPSBGQUxTRX0KCiNnZW9jb2RlIHRoZSBlbGVtZW50cyBvZiBleHRyYWN0ZWRfYWRkcmVzcywgdXNpbmcgdGhlIGZ1bmN0aW9uIGdlb2NvZGVfcGF1c2UKY3JpbWVfdG9fMTIwNjIwMTZfbGVmdG92ZXJzX2dlb2NvZGUgPC0gY3JpbWVfdG9fMTIwNjIwMTZfbGVmdG92ZXJzICU+JSAKICBtdXRhdGUobG9jYXRpb24gPSBtYXAoZXh0cmFjdGVkX2FkZHJlc3MsIGdlb2NvZGVfcGF1c2UpKQoKI3NhdmUgdGhlIHJlc3VsdHMsIHRvIGF2b2lkIGhhdmluZyB0byBnZW9jb2RlIGFnYWluIHdoZW4gcmVydW5uaW5nIHRoZSBhbmFseXNpcwp3cml0ZV9yZHMoY3JpbWVfdG9fMTIwNjIwMTZfbGVmdG92ZXJzX2dlb2NvZGUsICIuL2RhdGEvY3JpbWVfdG9fMTIwNjIwMTZfbGVmdG92ZXJzX2dlb2NvZGUucmRzIikKCmBgYAoKCgpgYGB7cn0KCmNyaW1lX3RvXzEyMDYyMDE2X2xlZnRvdmVyc19nZW9jb2RlIDwtIHJlYWRfcmRzKCIuL2RhdGEvY3JpbWVfdG9fMTIwNjIwMTZfbGVmdG92ZXJzX2dlb2NvZGUucmRzIikKCiNjdXQgb3V0IHRoZSBjb2x1bW4gd2UgdXNlZCBmb3IgZ2VvY29kaW5nCmNyaW1lX3RvXzEyMDYyMDE2X2xlZnRvdmVyc19nZW9jb2RlIDwtIAogIGNyaW1lX3RvXzEyMDYyMDE2X2xlZnRvdmVyc19nZW9jb2RlICU+JSBzZWxlY3QoLWV4dHJhY3RlZF9hZGRyZXNzKQogIAojY3V0IG91dCBvZiB0aGUgZ2VvY29kZSBmYWlsdXJlcyBhbmQgcHV0IHRoZSBsb2NhdGlvbiBpbmZvcm1hdGlvbiBpbnRvIHRoZSBjb2x1bW5zIGxhdCBhbmQgbG9uCmNyaW1lX3RvXzEyMDYyMDE2X2xlZnRvdmVyc19nZW9jb2RlIDwtIAogIHJlbW92ZV9udWxsX2xvY2F0aW9ucyhjcmltZV90b18xMjA2MjAxNl9sZWZ0b3ZlcnNfZ2VvY29kZSkgJT4lCiAgdW5uZXN0KGxvY2F0aW9uKQoKI2NyZWF0ZSBhIHNpbXBsZSBmZWF0dXJlcyAoc2YpIG9iamVjdCwgdXNpbmcgdGhlIGxhdGl0aXR1ZGVzIGFuZCBsb25naXR1ZGVzCmNyaW1lX3RvXzEyMDYyMDE2X2xlZnRvdmVyc19zZiA8LSBzdF9hc19zZihjcmltZV90b18xMjA2MjAxNl9sZWZ0b3ZlcnNfZ2VvY29kZSwgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGNvb3JkcyA9IGMoImxvbiIsICJsYXQiKSwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgY3JzID0gNDMyNikKCiNhcHBlbmQgdGhpcyBzaW1wbGUgZmVhdHVyZXMgZGF0YWZyYW1lIHRvIHRoZSBkYXRhZnJhbWUgZm9yIHdoaWNoIHdlIGFscmVhZHkgaGFkIGxvY2F0aW9ucwpjcmltZV90b18xMjA2MjAxNl9zZiA8LSByYmluZChjcmltZV90b18xMjA2MjAxNl9zcGxpdFtbMV1dLCBjcmltZV90b18xMjA2MjAxNl9sZWZ0b3ZlcnNfc2YpCgpybShjcmltZV90b18xMjA2MjAxNiwgY3JpbWVfdG9fMTIwNjIwMTZfbGVmdG92ZXJzX2dlb2NvZGUsIGNyaW1lX3RvXzEyMDYyMDE2X2xlZnRvdmVyc19zZiwgY3JpbWVfdG9fMTIwNjIwMTZfbGVmdG92ZXJzLCBjcmltZV90b18xMjA2MjAxNl9zcGxpdCkKCmBgYAoKCmBgYHtyfQoKI2NvbnNpZGVyIHRoZSBleGFtcGxlcyBpbiB0aGUgcmVjZW50IGNyaW1lIGRhdGEgZm9yIHdoaWNoIHRoZSBjb252ZXJzaW9uIHRvIHNmIGRpZG4ndCB3b3JrLCByZW1vdmUgdGhlIHR3byBjb2x1bW5zIHRoYXQgd2UgaGF2ZSBhZGRlZCwgYW5kIGNyZWF0ZSBhbmQgYWRkcmVzcyBjb2x1bW4gZm9yIGdlb2NvZGluZwpjcmltZV8xMjA2MjAxNl90b18wMzE5MjAxOF9sZWZ0b3ZlcnMgPC0gY3JpbWVfMTIwNjIwMTZfdG9fMDMxOTIwMThfc3BsaXRbWzJdXSAlPiUKICBzZWxlY3QoLWV4dHJhY3RlZF9sYXQsIC1leHRyYWN0ZWRfbG9uKSAlPiUKICBtdXRhdGUoZXh0cmFjdGVkX2FkZHJlc3MgPSBzdHJfYyhgSW5jaWRlbnQgQWRkcmVzc2AsICIsIERldHJvaXQsIE1pY2hpZ2FuIikpCgpgYGAKCmBgYHtyLCBldmFsID0gRkFMU0V9CgpjcmltZV8xMjA2MjAxNl90b18wMzE5MjAxOF9nZW9jb2RlIDwtIGNyaW1lXzEyMDYyMDE2X3RvXzAzMTkyMDE4X2xlZnRvdmVycyAlPiUgCiAgbXV0YXRlKGxvY2F0aW9uID0gbWFwKGV4dHJhY3RlZF9hZGRyZXNzLCBnZW9jb2RlX3BhdXNlKSkKCndyaXRlX3JkcyhjcmltZV8xMjA2MjAxNl90b18wMzE5MjAxOF9nZW9jb2RlLCAiLi9kYXRhL2NyaW1lXzEyMDYyMDE2X3RvXzAzMTkyMDE4X2dlb2NvZGUucmRzIikKCmBgYAoKYGBge3J9CgpjcmltZV8xMjA2MjAxNl90b18wMzE5MjAxOF9nZW9jb2RlIDwtIHJlYWRfcmRzKCIuL2RhdGEvY3JpbWVfMTIwNjIwMTZfdG9fMDMxOTIwMThfZ2VvY29kZS5yZHMiKSAlPiUKICBzZWxlY3QoLWV4dHJhY3RlZF9hZGRyZXNzKQoKI3JlbW92ZSB0aGUgcm93cyBmb3Igd2hpY2ggdGhlIHZhbHVlIG9mIGxvY2F0aW9uIGlzIE5VTEwgYW5kIHRoZW4gdW5uZXN0IHRoZSByZW1haW5pbmcgbG9jYXRpb25zCmNyaW1lXzEyMDYyMDE2X3RvXzAzMTkyMDE4X2dlb2NvZGUgPC0gCiAgcmVtb3ZlX251bGxfbG9jYXRpb25zKGNyaW1lXzEyMDYyMDE2X3RvXzAzMTkyMDE4X2dlb2NvZGUpICU+JQogIHVubmVzdChsb2NhdGlvbikKCiNjb252ZXJ0IHRoZSBkYXRhZnJhbWUgdG8gYSBzaW1wbGUgZmVhdHVyZXMgc2V0CmNyaW1lXzEyMDYyMDE2X3RvXzAzMTkyMDE4X3NmIDwtIHN0X2FzX3NmKGNyaW1lXzEyMDYyMDE2X3RvXzAzMTkyMDE4X2dlb2NvZGUsIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBjb29yZHMgPSBjKCJsb24iLCAibGF0IiksCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGNycyA9IDQzMjYpICAKCiNjb21iaW5lIHRoZSBnZW9jb2RlZCBkYXRhIHdpdGggdGhlIHNmIGRhdGFmcmFtZSBjcmVhdGVkIGVhcmxpZXIKY3JpbWVfMTIwNjIwMTZfdG9fMDMxOTIwMTggPC0gcmJpbmQoY3JpbWVfMTIwNjIwMTZfdG9fMDMxOTIwMThfc3BsaXRbWzFdXSwgY3JpbWVfMTIwNjIwMTZfdG9fMDMxOTIwMThfc2YpCgpybShjcmltZV8xMjA2MjAxNl90b18wMzE5MjAxOF9zcGxpdCwgY3JpbWVfMTIwNjIwMTZfdG9fMDMxOTIwMThfZ2VvY29kZSwgY3JpbWVfMTIwNjIwMTZfdG9fMDMxOTIwMThfbGVmdG92ZXJzLCBjcmltZV8xMjA2MjAxNl90b18wMzE5MjAxOF9zZikKCmBgYAoKYGBge3J9CgojZ2VvY29kZSB0aGUgb25lIGl0ZW0gaW4gdGhlIEltcHJvdmUgRGV0cm9pdCBJc3N1ZXMgZGF0YSBmb3Igd2hpY2ggdGhlIGdpdmVuIGNvb3JkaW5hdGVzIHdlcmUgb2J2aW91c2x5IGluY29ycmVjdCwgYW5kIHRoZW4gY29udmVydCB0byBhbiBzZiBvYmplY3QuIElmIGdlb2NvZGluZyBmYWlscywgcnVuIHRoaXMgYml0IGFnYWluCmltcHJvdmVfZGV0cm9pdF9pc3N1ZXNfbGVmdG92ZXJfc2YgPC0gaW1wcm92ZV9kZXRyb2l0X2lzc3Vlc19zcGxpdFtbMl1dICU+JQogIHNlbGVjdCgtZXh0cmFjdGVkX2xhdCwgLWV4dHJhY3RlZF9sb24pICU+JQogIG11dGF0ZShsb2NhdGlvbiA9IG1hcChBZGRyZXNzLCBnZW9jb2RlX3BhdXNlKSkgJT4lCiAgdW5uZXN0KGxvY2F0aW9uKSAlPiUgCiAgc3RfYXNfc2YoY29vcmRzID0gYygibG9uIiwgImxhdCIpLCBjcnMgPSA0MzI2KSAgCgojc3BsaWNlIHdpdGggdGhlIHByZXZpb3VzbHkgZ2VuZXJhdGVkIHNmIGRhdGFmcmFtZQppbXByb3ZlX2RldHJvaXRfaXNzdWVzIDwtIHJiaW5kKGltcHJvdmVfZGV0cm9pdF9pc3N1ZXNfc3BsaXRbWzFdXSwgaW1wcm92ZV9kZXRyb2l0X2lzc3Vlc19sZWZ0b3Zlcl9zZikKCnJtKGltcHJvdmVfZGV0cm9pdF9pc3N1ZXNfc3BsaXQsIGltcHJvdmVfZGV0cm9pdF9pc3N1ZXNfbGVmdG92ZXJfc2YpCgpgYGAKCldlIGJlZ2luIHRoZSBhc3NpZ25tZW50IG9mIGxhYmVscyB0byB0aGUgYnVpZGluZ3M6IGJsaWdodGVkIG9yIG5vdCBibGlnaHRlZC4gQnVpbGRpbmdzIHdpbGwgYmUgcmVwcmVzZW50ZWQgYnkgcGFyY2VscyB0aGF0IGhhdmUgb3IgaGF2ZSBoYWQgYnVpbGRpbmdzIG9uIHRoZW0sIHdoZXRoZXIgYnkgYmVpbmcgc28gcmVwcmVzZW50ZWQgYXMgaW4gdGhlIGBwYXJjZWxzX3NmYCBkYXRhIGZyYW1lIGFzIGluY2x1ZGluZyBzdHJ1Y3R1cmVzIG9yIGluIHRoZSBkaXNtYW50bGUgcGVybWl0cyBkYXRhZnJhbWUgYXMgaGF2aW5nIGhhZCBhIGRpc21hbnRlIHBlcm1pdCBhc3NvY2lhdGVkIHdpdGggaXQsIHRodXMgc3VnZ2VzdGluZyB0aGF0IHRoZXJlICp3YXMqIGEgYnVpbGRpbmcgb24gdGhlIHBhcmNlbC4gCgpXZSB3aWxsIHVzZSBwYXJjZWwgbnVtYmVycyB0byByZWZlciB0byB0aGUgcGFyY2Vscy4gVGhpcyB3b3JrcyBiZWNhdXNlIHBhcmNlbG51bSBjb2x1bW4gY29udGFpbnMgbm8gcmVwZWF0cyBvdmVyIGRpZmZlcmVudCByb3dzIChzZWUgYmVsb3csIGluIHdoaWNoIGBkdXBsaWNhdGVfcGFyY2VsX251bWJlcnNfaW5fcGFyY2VsX2RhdGFgIGhhcyB6ZXJvIHJvd3MpLiAKCmBgYHtyfQojQXMgcGVyIGFib3ZlLCBmb2xsb3dpbmcgcmV0dXJucyBhbiBlbXB0eSBkYXRhIGZyYW1lCmR1cGxpY2F0ZV9wYXJjZWxfbnVtYmVyc19pbl9wYXJjZWxfZGF0YSA8LSAKICBwYXJjZWxfc2YgJT4lCiAgZ3JvdXBfYnkocGFyY2VsbnVtKSAlPiUgCiAgbXV0YXRlKG4gPSBuKCkpICU+JQogIHVuZ3JvdXAoKSAlPiUgCiAgZmlsdGVyKG4gPiAxKQpkdXBsaWNhdGVfcGFyY2VsX251bWJlcnNfaW5fcGFyY2VsX2RhdGEKcm0oZHVwbGljYXRlX3BhcmNlbF9udW1iZXJzX2luX3BhcmNlbF9kYXRhKQpgYGAKVGhlIGRpc21hbnRsZSBwZXJtaXRzIGRhdGEsIGhvd2V2ZXIsIG1heSBzZWVtIGxlc3MgY2xlYW4gdGhhbiB0aGUgcGFyY2VsX3NmLCBhcyBpdCBjb250YWlucyByZXBldGl0aW9ucyBvZiB0aGUgcGFyY2VsIG51bWJlcnMgdGhhdCBjb3JyZXNwb25kIHRvIGRpZmZlcmVudCBhZGRyZXNzZXMgdGhhdCB3b3VsZCByZWZlciwgaW4gc29tZSBjYXNlcywgdG8gZGlzdGluY3QgbG9jYXRpb25zLiAoSXQgYWxzbyBpbmRpY2F0ZXMgdGhhdCBhIGZldyBpbmRpdmlkdWFsIGxvY2F0YXRpb25zLCBpZGVudGlmaWVkIHdpdGggYWRkcmVzc2VzLCBoYWQgbW9yZSB0aGFuIG9uZSBhc3NvY2lhdGVkIGRpc21hbnRsZSBwZXJtaXQuIFRoaXMgbmVlZCBub3QgYmUgcHJvYmxlbWF0aWMtLS1hIHBlcm1pdCBjb3VsZCBleHBpcmUgYmVmb3JlIHRoZSB3b3JrIGlzIGNhcnJpZWQgb3V0LCBvciB0aGVyZSBjb3VsZCBiZSBtb3JlIHRoYW4gb25lIHN0cnVjdHVyZSBvbiBhIHBhcmNlbC4pICBUaGVzZSByZXBldGl0aW9ucyBhcmUgaW4gYGR1cGxpY2F0ZV9wYXJjZWxfbnVtYmVyc19vdmVyX2Rpc3RpbmN0X2FkZHJlc3Nlc2AsIHdoaWNoIGNvbnRhaW5zIDI2MCByb3dzLiBJIHNob3VsZCBhbHNvIG5vdGUgdGhhdCwgaW4gIG1vc3Qgb2YgdGhlc2UgY2FzZXMgd2l0aCBkdXBsaWNhdGUgcGFyY2VsIG51bWJlcnMgKGFuZCBhZGRyZXNzZXMgaW5kaWNhdGluZyBkaWZmZXJlbnQgbG9jYXRpb25zKSwgdGhlIHJlY29yZGVkIGxhdGl0dWRlIGFuZCBsb25naXR1ZGUgYXJlIGlkZW50aWNhbC4gV2UgY2FuIHRodXMgaW5mZXIgdGhhdCBzb21lIG9mIHRoaXMgbG9jYXRpb24gaW5mb3JtYXRpb24gaXMgaW5jb3JyZWN0LgpgYGB7cn0KZHVwX3Bhcl9udW1faW5fZGlzbWFudGxlX2RhdGEgPC0KICBkaXNtYW50bGVfcGVybWl0c19zZiAlPiUKICBncm91cF9ieShgUGFyY2VsIE51bWJlcmApICU+JSAKICBtdXRhdGUobiA9IG4oKSkgJT4lCiAgdW5ncm91cCgpICU+JSAKICBmaWx0ZXIobiA+IDEpICU+JQogIHNlbGVjdChgUGFyY2VsIE51bWJlcmAsIGBTaXRlIEFkZHJlc3NgKQphcy5kYXRhLmZyYW1lKGR1cF9wYXJfbnVtX2luX2Rpc21hbnRsZV9kYXRhKQpybShkdXBfcGFyX251bV9pbl9kaXNtYW50bGVfZGF0YSkKCiNwYXJjZWwgbnVtYmVycyBpbiB0aGUgZGlzbWFudGxlIHBlcm1pdHMgZGF0YSB0aGF0IGFyZSBkaXN0cmlidXRlZCBvdmVyIGRpc2luY3QgYWRkcmVzc2VzZXMKZHVwX3Bhcl9udW1fb3Zlcl9kaXN0aW5jdF9hZGRyZXNzZXMgPC0gCiAgZGlzbWFudGxlX3Blcm1pdHNfc2YgJT4lCiAgZ3JvdXBfYnkoYFBhcmNlbCBOdW1iZXJgKSAlPiUKICBtdXRhdGUocGFyY2VsX251bWJlcl9vY2N1cmFuY2VzID0gbigpKSAlPiUKICB1bmdyb3VwKCkgJT4lCiAgZmlsdGVyKHBhcmNlbF9udW1iZXJfb2NjdXJhbmNlcyA+IDEpICU+JQogIHNlbGVjdChgUGFyY2VsIE51bWJlcmAsIGBTaXRlIEFkZHJlc3NgLCBwYXJjZWxfbnVtYmVyX29jY3VyYW5jZXMpICU+JQogIGdyb3VwX2J5KGBQYXJjZWwgTnVtYmVyYCwgYFNpdGUgQWRkcmVzc2ApICU+JQogIG11dGF0ZShtID0gbigpKSAlPiUKICBmaWx0ZXIobSA8IHBhcmNlbF9udW1iZXJfb2NjdXJhbmNlcykgJT4lCiAgYXJyYW5nZShgUGFyY2VsIE51bWJlcmApCmFzLmRhdGEuZnJhbWUoZHVwX3Bhcl9udW1fb3Zlcl9kaXN0aW5jdF9hZGRyZXNzZXMpCnJtKGR1cF9wYXJfbnVtX292ZXJfZGlzdGluY3RfYWRkcmVzc2VzKQoKYGBgClNvbWUgb2YgcmVwZWF0cyBvZiB0aGUgcGFyY2VsIG51bWJlcnMgd291bGQgc2VlbSB0byBjb3JyZXNwb25kIHRvIHRoZSBzb21lIGxvY2F0aW9uICh3aXRoIHRoZSBhZGRyZXNzZXMgcmVjb3JkZWQgc29tZXdoYXQgZGlmZmVyZW50bHkpLCB3aGlsZSBvdGhlcnMgd291bGQgbm90LiBUaGUgbnVtYmVyIG9mIHJvd3MgaW4gcXVlc3Rpb24gaXMgcmVsYXRpdmVseSBzbWFsbCAoMjcyKSwgc28gSSB3aWxsIGlnbm9yZSB0aGUgaXNzdWUgZm9yIG5vdy4gKEkgd2lsbCBldmVudHVhbGx5IGVpdGhlciByZW1vdmUgdGhpcyBkYXRhIGFyZSBhdHRlbXB0IHRvIGF0dGFjaGUgdGhlIGNvcnJlY3QgbG9jYXRpb24gaW5mb3JtYXRpb24uKQoKYGBge3IsIGV2YWwgPSBGQUxTRX0KI25vdGUgdGhhdCB0aGUgZm9sbG93aW5nIHJlbW92ZXMgcm93cyB3aXRoIGR1cGxpY2F0ZSBwYXJjZWxzCiNkdXBsaWNhdGVfcGFyY2VsX251bWJlcnMgJT4lIGRpc3RpbmN0KHBhcmNlbG51bSwgLmtlZXBfYWxsID0gVFJVRSkKCnBhcmNlbF9qb2luX3NmX3BhcmNlbF9maXJzdCA8LSAKICBmdWxsX2pvaW4ocGFyY2VsX3NmICU+JSBzZWxlY3QocGFyY2VsbnVtKSwKICAgICAgICAgICAgZGlzbWFudGxlX3Blcm1pdHNfc2YgJT4lIGFzLmRhdGEuZnJhbWUoKSAlPiUgc2VsZWN0KGBQYXJjZWwgTnVtYmVyYCksCiAgICAgICAgICAgIGMoInBhcmNlbG51bSIgPSAiUGFyY2VsIE51bWJlciIpKSAlPiUKICBhcnJhbmdlKGBQYXJjZWwgTnVtYmVyYCkKCnBhcmNlbF9qb2luX3NmX2Rpc21hbnRsZV9maXJzdCA8LQogIGZ1bGxfam9pbihkaXNtYW50bGVfcGVybWl0c19zZiAlPiUgc2VsZWN0KGBQYXJjZWwgTnVtYmVyYCksIAogICAgICAgICAgICBwYXJjZWxfc2YgJT4lIGFzLmRhdGEuZnJhbWUoKSAlPiUgc2VsZWN0KHBhcmNlbG51bSksCiAgICAgICAgICAgIGMoIlBhcmNlbCBOdW1iZXIiID0gInBhcmNlbG51bSIpKSAlPiUKICBhcnJhbmdlKGBQYXJjZWwgTnVtYmVyYCkKCnN0X2NycyhwYXJjZWxfc2YpCnN0X2NycyhkaXNtYW50bGVfcGVybWl0c19zZikKCiNCb3RoIG9mIHRoZXNlIHlpZWxkIGFuIEVQU0cgb2YgNDMyNi4gTmV0aGVyZWxlc3MsIHRoZSBmb2xsb3cgc3RlcCBzZWVtcyBuZWNlc3NhcnkuCgpzdF9jcnMoZGlzbWFudGxlX3Blcm1pdHNfc2YpIDwtIHN0X2NycyhwYXJjZWxfc2YpCgp0ZW1wIDwtIHN0X2pvaW4oZGlzbWFudGxlX3Blcm1pdHNfc2YsIHBhcmNlbF9zZiwgam9pbiA9IHN0X3dpdGhpbikKICAKdGVtcDIgPC0gdGVtcCAlPiUgZmlsdGVyKGBQYXJjZWwgTnVtYmVyYCAhPSBwYXJjZWxudW0pCgp0ZW1wMiA8LSB0ZW1wMiAlPiUgc2VsZWN0KGBQYXJjZWwgTnVtYmVyYCwgcGFyY2VsbnVtLCBgU2l0ZSBBZGRyZXNzYCwgYWRkcmVzcykKCgojbm90ZSB0aGF0IG9iamVjdGlkIGluIHBhcmNlbF9zZiBoYXMgbm8gTkEgdmFsdWVzLCBhbmQgdGhhdCBvYmplY3RpZCBpcyBhIGtleSBpbiBwYXJjZWxfc2YKcGFyY2VsX3NmICU+JSBhcy5kYXRhLmZyYW1lKCkgJT4lIGZpbHRlcihpcy5uYShvYmplY3RpZCkpCnBhcmNlbF9zZiAlPiUgY291bnQob2JqZWN0aWQpICU+JSBmaWx0ZXIobiA+IDEpCgojbm90ZSB0aGF0IGBQZXJtaXQgTnVtYmVyYCBpcyBhIGFsc28gYSBrZXksIGZvciBkaXNtYW50bGVfcGVybWl0c19zZgpkaXNtYW50bGVfcGVybWl0c19zZiAlPiUgYXMuZGF0YS5mcmFtZSgpICU+JSBmaWx0ZXIoaXMubmEoYFBlcm1pdCBOdW1iZXJgKSkKZGlzbWFudGxlX3Blcm1pdHNfc2YgJT4lIGNvdW50KGBQZXJtaXQgTnVtYmVyYCkgJT4lIGZpbHRlcihuID4gMSkKCiN3aXRoIHRoZSBhYm92ZSBpbiBtaW5kLCB3ZSBleGFtaW5lIHRoZSBOQSB2YWx1ZXMgZm9yIHRoZXNlIGNvbHVtbnMgaW4gb3VyIGZ1bGwgam9pbiwgYmVnaW5uaW5nIHdpdGggb2JqZWN0aWQgaW4gcGFyY2VsX3NmLiBUaGUgaWRlYSBpcyB0aGF0IGFueSBOQSB2YWx1ZSBmb3Igb2JqZWN0aWQgaW4gcGFyY2VsX2pvaW4gd291bGQgY29ycmVzcG9uZCB0byBhIHBhcmNlbCBpbiB0aGUgZGlzbWFudGxlIHBlcm1pdHMgZGF0YXNldCB0aGF0IGlzIGVpdGhlciBub3QgcmVmbGVjdGVkIGluIHRoZSBwYXJjZWxzIGRhdGFzZXQgb3IgZm9yIHdoaWNoIHRoZXJlIGlzIGEgZmxhdyBpbiB0aGUgZGF0YS4KcGFyY2VsX2pvaW4gJT4lIGZpbHRlcihpcy5uYShvYmplY3RpZCkpCgpkaXNtYW50bGVfcGVybWl0c19zZiAlPiUgZmlsdGVyKGBQYXJjZWwgTnVtYmVyYCA9PSAiMjIxMDg1MTIuIikKCiNkaXNtYW50bGVkX3N0cnVjdHVyZXMgPC0gaW5pdGlhbF9qb2luICU+JSBmaWx0ZXIoIWlzLm5hKGBQZXJtaXQgTnVtYmVyYCkpCgpwYXJjZWxfc2YgJT4lIGZpbHRlcihwYXJjZWxudW0gPT0gIjIyMTA4NTEyLiIpCgpwYXJjZWxfdG1wIDwtIGJsaWdodF92aW9sYXRpb25zX3NmW2MoMSwgMiksXQoKc3RfZGlzdGFuY2UocGFyY2VsX3RtcCkKCm1fbGlzdCA8LSBtYXBwbHkoc3RfZGlzdGFuY2UsIGJsaWdodF92aW9sYXRpb25zX3NmJGdlb21ldHJ5WzFdLCBmcmVkJGdlb21ldHJ5KQoKZGlzbWFudGxlX3Blcm1pdHNfc2YgJT4lIGFzLmRhdGEuZnJhbWUoKSAlPiUgZmlsdGVyKGlzLm5hKGBQYXJjZWwgTnVtYmVyYCkpCgp0ZW1wNCA8LSBzdF9kaXN0YW5jZShwYXJjZWxfc2ZbMTk1MDk5LF0sIAogICAgICAgICAgICBibGlnaHRfdmlvbGF0aW9uc19zZlsyMjIzMzoyMjI1NSxdKQoKc3RfY3JzKGJsaWdodF92aW9sYXRpb25zX3NmKSA8LSBzdF9jcnMocGFyY2VsX3NmKQoKcGxvdChibGlnaHRfdmlvbGF0aW9uc19zZiwgbWF4LnBsb3QgPSAxKQoKYGBgCgpNYXBzOgoKYGBge3IsIGV2YWwgPSBGQUxTRX0KbGlicmFyeShnZ21hcCkKCmdncGxvdChibGlnaHRfdmlvbGF0aW9uc19zZiAlPiUgc2VsZWN0KGdlb21ldHJ5KSkgKwogIGdlb21fc2YoKSArIAogIGdlb21fZGVuc2l0eTJkKGRhdGEgPSBibGlnaHRfdmlvbGF0aW9uc19zZiAlPiUgc2VsZWN0KGdlb21ldHJ5KSkKCgpnZ3Bsb3QoZGF0YT14eS5zZikgKwogICAgZ2VvbV9zZigpICsKICAgIGdlb21fZGVuc2l0eTJkKGRhdGE9eHkuc2YsIGFlcyh4PXgseT15LGNvbG91cj0uLmxldmVsLi4pKQoKCmRldHJvaXRfZ2cgPC0gZ2V0X21hcCgiRGV0cm9pdCIsIG1hcHR5cGUgPSAidG9uZXItbGl0ZSIsCiAgICAgICAgICAgICAgICAgICAgICB6b29tID0gMTEpCgpnZ21hcChkZXRyb2l0X2dnKQpgYGAKCgoKCgoK